In an office, there is common use of calculating total working days between two given date. Excel provides NETWORKDAYS function for calculating working days. It returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. It is very useful to calculate employee benefits that accrue based on the number of days worked during a period. Steps are given below



Step 1: First create excel sheet with some dummy data as below

Count Workdays between Two Dates in Excel

Step 2: Select cell where we display total working days. Formula are given below

Count Workdays between Two Dates in Excel

Note: If you want to reduce Sunday from total working days then also maintain Sunday as holiday in excel sheet.

  Modified On Nov-29-2017 09:17:17 PM

Leave Comment