How to Use the WORKDAY Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: WORKDAY returns the date that is a set number of working days from a start date. The formula is =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])

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.

AB
1StartHoliday
211/2/202611/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

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.

Hint: two arguments are enough.

Exercise 2: Skip a holiday

Write a formula that returns the date 10 working days after A2, skipping the holiday in B2.

Hint: the holiday goes in the third argument.

What to learn next

Syntax and rules in this guide were checked against Google's WORKDAY help page. See all guides.