How to Calculate Working Days in Google Sheets
=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])
start_date: the first date of the period.end_date: the last date of the period.holidays(optional): a range or array of dates to exclude.
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.
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | Holiday |
| 2 | 11/2/2026 | 11/13/2026 | 11/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
- Typing dates inside the formula. Use cells or DATE.
- Holidays stored as text. They must be real dates.
- A different working week. If your weekend is not Saturday and Sunday, use NETWORKDAYS.INTL.
- Expecting weekend holidays to reduce the count again. They are already excluded.
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.
Exercise 2: Minus a holiday
Write a formula that returns the working days between A2 and B2, excluding the holiday in C2.
What to learn next
- Days between two dates: three ways to count the gap.
- DATEDIF: whole years, months or days between dates.
- TODAY: return the current date.
- WORKDAY: returns the date a set number of working days away.
Syntax and rules in this guide were checked against Google's NETWORKDAYS help page. See all guides.