Services offered worldwide
Your partner in computer software training & application development
for over 25 years
NETWORKDAYS & WORKDAY
© 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.
Here is an example of using the NETWORKDAYS function, using this formula:
Here is an example of using the WORKDAY function, using this formula: