Microsoft Excel articles et conseils

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.