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.