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
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.
