The NETWORKDAYS function
The number of working days between two dates, Monday to Friday, without the holidays you give it.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
In a French Excel: =NB.JOURS.OUVRES(date_début; date_fin; [jours_fériés]).
Arguments
- start_date and end_date: both bounds, included.
- holidays: a range of dates to exclude.
An example
=NETWORKDAYS(A2,B2,Holidays!$A$2:$A$12)
The working days between A2 and B2, without the holidays listed in the Holidays sheet.
Pitfalls
- Both bounds count: Monday to the next Monday is 6 days.
- Another weekend (Friday and Saturday): NETWORKDAYS.INTL.
Going further
Frequently asked questions
- Does Excel know public holidays?
- No: list them in a range and pass it as the third argument.