Home > DeveloperSection > Articles > Count Workdays between Two Dates in Excel

Count Workdays between Two Dates in Excel


Excel Excel 
Ratings:
0 Comment(s)
 3625  View(s)
Rate this:

Count Workdays between Two Dates in Excel

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

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.


Don't want to miss updates? Please click the below button!

Follow MindStick