Quick Answer & Formula
Excel
Sheets
Beginner
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) NETWORKDAYS.INTL calculates the number of working days between two dates, excluding weekends and public holidays: =NETWORKDAYS.INTL(StartDate, EndDate, 1, US_Holidays_Range).
NETWORKDAYS.INTL in Excel & Google Sheets
The NETWORKDAYS.INTL function calculates exact business workdays between two milestones, automatically skipping weekends and corporate holidays.
1. Basic Working Days (Standard Mon-Fri Workweek)
=NETWORKDAYS(A2, B2)2. Excluding US Federal Holidays
With Project Start in A2, Project End in B2, and Federal Holidays listed in H2:H15:
=NETWORKDAYS.INTL(A2, B2, 1, $H$2:$H$15)
?
Frequently Asked Questions
How do I exclude US Federal Holidays from working days?
Create a list of federal holiday dates in a column (e.g. H2:H12) and pass it to the 4th argument: =NETWORKDAYS.INTL(A2, B2, 1, $H$2:$H$12).