articles

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

Count Workdays between Two Dates in Excel

Count Workdays between Two Dates in Excel

AVADHESH PATEL5938 26-Mar-2013

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.


Updated 27-Dec-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By