Calculate Working Days Between Two Dates in Excel

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

Posted by Rich Kreider

Father, geek, caffeine addict, IT guy, photographer and after-hours hacker...

Leave a Reply

Your email address will not be published. Required fields are marked *

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