How to Calculate Working Days in Google Sheets

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

In short: NETWORKDAYS counts the working days between two dates, skipping Saturdays and Sundays. The formula is =NETWORKDAYS(start_date, end_date, [holidays]). List public holidays in the third argument to exclude them too.

What NETWORKDAYS does

Subtracting dates counts every calendar day. For deadlines and delivery times you usually want working days only. NETWORKDAYS skips weekends for you.

NETWORKDAYS syntax

=NETWORKDAYS(start_date, end_date, [holidays])

Per Google's help page, only Saturday and Sunday count as the weekend. For other weekend patterns, use NETWORKDAYS.INTL. The page also warns that dates typed like 10/10/2000 inside a formula are read as divisions, so use a cell reference or DATE().

A step-by-step example

Here are two weeks in November 2026 and one holiday, in cells A1:C2. November 2 is a Monday and November 13 is a Friday.

ABC
1StartEndHoliday
211/2/202611/13/202611/3/2026

Dates in the tables are shown in month/day/year order. The results do not depend on your display format.

=NETWORKDAYS(A2, B2)

This returns 10: five working days in each of the two weeks. The help page does not say whether the start and end dates are counted. In practice both are included when they fall on working days, so check your own data when the boundary matters.

Exclude holidays

Add the holiday date or a range of holiday dates as the third argument. The holiday in C2 falls on a Tuesday, so it removes one working day:

=NETWORKDAYS(A2, B2, C2)

This returns 9. For a whole year of holidays, keep them in a list and use that range.

Find a date instead of a count

To find the date that is a set number of working days away, use WORKDAY. The pair work together: NETWORKDAYS counts, WORKDAY returns a date.

Common mistakes

Try it yourself

Use the dates above (A2, B2 and C2). Type your formula into the box, starting with =, then press Check.

Exercise 1: Working days

Write a formula that returns the number of working days between the start date in A2 and the end date in B2.

Hint: two arguments are enough.

Exercise 2: Minus a holiday

Write a formula that returns the working days between A2 and B2, excluding the holiday in C2.

Hint: the holiday goes in the third argument.

What to learn next

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