How to Use the WORKDAY Function in Google Sheets
=WORKDAY(start_date, num_days, [holidays]). Saturdays, Sundays and any listed holidays are skipped.
What WORKDAY does
Adding 10 to a date lands 10 calendar days later, possibly on a weekend. WORKDAY counts only working days, which suits delivery dates, review deadlines and payment terms. It is the date-returning partner of NETWORKDAYS, which counts days.
WORKDAY syntax
=WORKDAY(start_date, num_days, [holidays])
start_date: the date counting starts from.num_days: how many working days to move. A negative number counts backwards. Decimals are truncated, so1.9works as1.holidays(optional): a range or array of dates to skip. They must be real dates, not text.
Only Saturday and Sunday count as the weekend. For other weekends, Google points to WORKDAY.INTL.
A step-by-step example
Cell A2 holds a start date of Monday, November 2, 2026, and B2 holds a holiday on Tuesday, November 3.
| A | B | |
|---|---|---|
| 1 | Start | Holiday |
| 2 | 11/2/2026 | 11/3/2026 |
Dates in the tables are shown in month/day/year order. The results do not depend on your display format.
=WORKDAY(A2, 10)
This returns Monday, November 16, 2026: ten working days is exactly two working weeks. Now skip the holiday:
=WORKDAY(A2, 10, B2)
This returns Tuesday, November 17, 2026. The holiday takes one day out of the count, so the deadline moves one working day later.
Common mistakes
- Typing the date inside the formula. Google's help page warns that typing a date such as
10/10/2000straight into the formula is read as a division, not a date. Use a cell reference orDATE(). - The result shows as a number. Format the cell as a date.
- Expecting a count. WORKDAY returns a date. To count working days, use NETWORKDAYS.
Try it yourself
Use the dates above (A2 and B2). Type your formula into the box, starting with =, then press Check.
Exercise 1: Ten working days
Write a formula that returns the date 10 working days after the start date in A2.
Exercise 2: Skip a holiday
Write a formula that returns the date 10 working days after A2, skipping the holiday in B2.
What to learn next
- NETWORKDAYS: count working days between two dates.
- EDATE: move a date forward or back by months.
- TODAY: return the current date.
Syntax and rules in this guide were checked against Google's WORKDAY help page. See all guides.