Calculate Working Days Between Two Dates in Excel

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

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

Leave a Comment