The function of Excel Networks.Iintl is used to restore the number of work days between starting dates and the end of dates, along with the integration or exclusion of the holidays.
Networkdays.intl function: a short intro
The excel Networkdays.intl Operating used to calculate the number of working day Between the starting dates and the end of dates with configure holiday dates and custom weekend.
|
Feature |
Networkdays |
Networkdays.intl |
|---|---|---|
|
Used for? |
Calculated working days between two dates |
Calculated working days at weekend Meanings |
|
What about the weekend days? |
Fixed (Saturday and Sunday only) |
Fully customizable (can choose any day (s) as weekends) |
|
Main syntax |
= Networkdays (start_date, end_date, [holidays]) |
= Networkdays.intl (start_date, end_date, [weekend], [holidays]) |
|
Holiday option |
Optional list of holidays |
Optional list of holidays |
|
Weekend customization support? |
Not supported |
Supported by numbers or a binary string |
|
Can be used for? |
Standard Business Weeks (Mon -Fri Work Week) |
Schedules not standard (sun-thu week week, spinning shifts) |
|
Functions introduced to? |
Excel 2007 |
Excel 2010 and later versions. |
Networkdays.intl function: a syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
- start_date: The Date of beginning of time.
- end_date: The ending date of time.
- Weekendekend: A string or number that represents where Sunday days are considered weekends.
- Holidays: A Dates range to exclude as holidays, and it is a Optional one.
List of weekend codes supported by networkdays.intl function:
|
Code |
Code |
|---|---|
|
1 |
Saturday, Sunday (Default) |
|
2 |
Sunday, Monday |
|
3 |
Monday, Tuesday |
|
4 |
Tuesday, Wednesday |
|
5 |
Wednesday, Thursday |
|
6 |
Thursday, Friday |
|
7 |
Friday, Saturday |
|
Binary Code |
That means |
|---|---|
|
0000011 |
Saturday and Sunday are weekends |
|
1111111 |
All day is weekends (0 work days) |
|
0000000 |
No weekend (day -day is a work day) |
|
1000001 |
Monday and Sunday are weekends |
|
0101010 |
Tuesday, Thursday, and Saturdays are weekends |
EXTREMELY EXAMPLE OF USE OF NETWORKDAYS FUNCTIONS.INTL:
In the following example, I explained how to use the Networkdays.intl Operating to calculate working days at Three different situations: There is no end of the week, Saturday and Sunday as weekendsand Sunday only as a weekend. I used to be well Both code formats (Binary and numerical) to identify the holidays. Please see.
The example may seem simple, but it is effective for quick understanding.
Example Example above:
- In this example, the formula = Networkdays.intl (b3, c3, “0000011”, l $ 3: l $ 4) calculated the number of working day between January 2, 2024, and January 31, 2024While not included weekend and holidays.
- The code “0000011” Excel says that Saturday and Sunday is considered weekend. The holiday list at Cells L3: L4 Includes January 1But since it fell out of date scope, weekends were excluded.
- From more on January 2024 May 8 days of the weekendExcel deducts them from the whole 31 days of the moon, resulting in 22 working days.
How networkday.intl calculated working days
Is there any formula available to copy networkdays.intl function?
Yes, there is a manu -manu formula available; You may need to use other Excel functions combined to get the results.
Scenarios
That's it. This article was originally published on How to Use Excel Networkdays.intl function?
