NETWORKDAYS counts business days between two dates and excludes weekends. You can also exclude public holidays.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
Basic example
With the start date in A2 and the end date in B2:
=NETWORKDAYS(A2, B2)
Both the start and end dates are counted if they are working days.
Exclude holidays
List your public holidays in a range, for example F2:F12, and add it as the third argument:
=NETWORKDAYS(A2, B2, $F$2:$F$12)
Different weekends: NETWORKDAYS.INTL
If your weekend is Friday and Saturday, or you work six days a week, use:
=NETWORKDAYS.INTL(A2, B2, 7, $F$2:$F$12)
The third argument is a weekend code. Code 1 is Saturday and Sunday, 7 is Friday and Saturday, and 11 is Sunday only.
Find a deadline: WORKDAY
=WORKDAY(A2, 10, $F$2:$F$12) returns the date that is 10 working days after A2.
Useful for
- Project schedules and delivery dates.
- Turnaround time (TAT) reports.
- Payroll and leave calculations.
Make sure the dates are real dates, not text, or you will get #VALUE!.