How to determine the working days between two dates in Excel?
September 19, 2007 by Mark Marucot · Leave a Comment
If I have a Start Date and End Date columns, how to I determine how many working days between them?
You can use the function NETWORKDAYS. To use this function you need to do the following:
1.Select Tools Add-in.
2.Checked the Tools Analysis Pack
3.Click the OK button.
CODE:
-
NETWORKDAYS<span style="color: #66cc66;">(</span>start_date,end_date,holidays<span style="color: #66cc66;">)</span>
where
Start_date is a date that represents the start date.
End_date is a date that represents the end date.
Holidays is an optional range of one or more days (holidays) to exclude from the working calendar.
Example 1:
Start_date: August 17, 2006
End_date: August 21, 2006
CODE:
-
= NETWORKDAYS(August 17, 2006,August 21, 2006)
The formula above will return 3. This means there are 3 working days between August 17, 2006 and August 21, 2006.
