Calculate Working Days Between Two Dates in Excel

This content 6 years old. Please, read this page keeping its age in mind along with the fact technology changes fast and the information on this page me be outdated, not best practice, or plain wrong.

A quick tip in Excel (2010, 2013) for calculating working days between two dates.

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

[su_box title=Tip box_color=#94c051 title_color=#ffffff]To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function.[/su_box]

Example Screenshots

2014-05-09_162206

2014-05-09_162227

2014-05-09_162236

 

Including Holidays

To include holidays that are to not be considered a working day into this calculation, simply create a list of holiday dates to reference.  Notice that in the example, May has a holiday so the number of working days is now 21.

2014-05-09_164758

2014-05-09_164812

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.