NETWORKDAYS Function (Functions in Excel)
Start Date | End Date | Work Days | |
1-Mar-98 | 7-Mar-98 | 5 | =NETWORKDAYS(C4,D4) |
25-Apr-98 | 30-Jul-98 | 69 | =NETWORKDAYS(C5,D5) |
24-Dec-98 | 5-Jan-99 | 9 | =NETWORKDAYS(C6,D6) |
What Does It Do? |
This function will calculate the number of working days between two dates. |
It will exclude weekends and any holidays. |
Syntax |
=NETWORKDAYS(StartDate,EndDate,Holidays) |
Holidays : This is a list of dates which will be excluded from the calculation, such as Xmas |
and Bank holidays. |
Formatting |
The result will be shown as a number. |
Note |
The calculation does not include the last day. The result of using 1-Jan-98 and 5-Jan-98 will |
give a result of 4. To correct this add 1 to the result. =NETWORKDAYS(Start,End,Holidays)+1 |
Example |
The following example shows how a list of Holidays can be created. |
Start Date | End Date | Work Days | |
Mon 02-Mar-98 | Fri 06-Mar-98 | 5 | =NETWORKDAYS(B28,C28,C33:C37) |
Mon 02-Mar-98 | Fri 13-Mar-98 | 10 | =NETWORKDAYS(B29,C29,C33:C37) |
Mon 27-Apr-98 | Fri 01-May-98 | 4 | =NETWORKDAYS(B30,C30,C33:C37) |
Holidays | |
Bank Holiday | 1-May-98 |
Xmas | 25-Dec-98 |
New Year | 1-Jan-97 |
New Year | 1-Jan-98 |
New Year | 1-Jan-99 |
0 comments:
Post a Comment