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
Syntax
NETWORKDAYS(start_date,end_date,holidays)
Step 1: First create excel sheet with some dummy data as below
Step 2: Select cell where we display total working days. Formula are given below
Note: If you want to reduce Sunday from total working days then also maintain Sunday as holiday in excel sheet.
Leave Comment