top of page

Microsoft Excel articles et conseils

Excel Icon.png
Back Button

© 2009 DJH Training & Application Solutions Inc - Updated 2022

QUESTION:  How can I figure out the number of work days, excluding holidays and weekends, between two dates?​

​

ANSWER:  Use the NETWORKDAYS function.  The components of this function are start date, end date, holidays (optional).  The WORKDAY function is also useful to calculate a due date based on a start date, number of days, holidays (optional).

​

​If you would like to include statutory holidays, create a table that lists them first (we named this partial example tblHolidays).  The Holiday column is added for clarity and is optional.

Networkdays 1.png

Here is an example of using the NETWORKDAYS function, using this formula:

=NETWORKDAYS(B2,C2,tblHolidays[Date])

Networkdays 2.png

Here is an example of using the WORKDAY function, using this formula:

=WORKDAY(B2,C2,tblHolidays[Date])

Networkdays 3.png
bottom of page