Google Sheets: Count Weekdays Between Dates

Yes. In Google Sheets, use =NETWORKDAYS(A2,B2) to count Monday-through-Friday workdays between the start date in A2 and the end date in B2, including both dates when they are weekdays. Add a holiday range as a third argument to exclude holidays too.

Count weekdays between two dates

Enter a start date in A2 and an end date in B2. With those dates in place, the formula =NETWORKDAYS(A2,B2) returns the number of weekdays in the inclusive date range. For example, if A2 contains March 3, 2025, and B2 contains March 7, 2025, the result is 5: Monday, Tuesday, Wednesday, Thursday, and Friday.

NETWORKDAYS is the simplest choice when a standard workweek means Monday through Friday. Saturday and Sunday are excluded automatically. The count is about weekdays, not the number of full 24-hour periods between two dates, so the result can be different from subtracting one date from another.

Both endpoints are considered. If a range starts on a Monday and ends on a Wednesday, all three weekdays count. If an endpoint falls on a Saturday or Sunday, it contributes zero, but weekdays elsewhere in the range still count. A range covering only a Saturday and Sunday therefore returns 0.

What NETWORKDAYS counts

NETWORKDAYS counts whole calendar dates that fall on workdays; it does not calculate hours, shifts, or partial days. A start date or end date with a time attached is treated as its calendar date for this purpose. If you need to count working hours or account for a half-day, NETWORKDAYS alone is not enough: you will need a separate time-based calculation or a clearly defined adjustment.

The function uses the spreadsheet’s date values, rather than interpreting the visible text alone. A date may display as “Mar 3” while its underlying value is a serial number. That is normal. However, a date typed or imported as plain text may not be recognized as a date, which can cause a formula error or an unintended result.

NETWORKDAYS is useful for estimating business-day spans in schedules, tracking turnaround time, and counting school or office days. Its standard weekend is fixed to Saturday and Sunday. If your organization follows a different workweek, use NETWORKDAYS.INTL instead.

Exclude public holidays

To leave holidays out of the total, list the holiday dates in a range and pass that range as the third argument. With a start date in A2, an end date in B2, and holiday dates in D2:D5, use =NETWORKDAYS(A2,B2,D2:D5). If A2 is March 3, 2025, B2 is March 7, 2025, and D2 contains March 5, 2025, the result is 4 because Wednesday is excluded as a holiday.

Put each holiday in its own cell as a real date. Holidays outside the start-to-end range have no effect, and a holiday that falls on a Saturday or Sunday does not reduce the weekday count again. Repeated dates in the holiday range should be avoided because duplicate holiday entries can affect the count more than once.

A maintained holiday list is often more reliable than embedding dates inside a formula. It is easier to review, update for a new year, and share with colleagues. You can also label the list in a separate column, such as “Holiday name” beside “Date,” while passing only the date cells to the function.

Count weekdays in a list of dates

Sometimes the dates are already listed individually rather than represented by a start and end date. For example, a sign-up sheet, delivery log, or attendance record may have dates in A2:A10. If those cells contain actual dates or blanks, the following formula counts only Monday-through-Friday entries: =SUMPRODUCT((A2:A10<>