Home Computer Learn Excel Networkdays advance formula.

Learn Excel Networkdays advance formula.

1 min read
0
0
53
1st.02

NETWORKDAYS

Learn all about Networkdays excel formula

 

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.
Networkday Excel Advance formula example -1
Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…