DEFINITION: WORKDAY.INTL Function Required A Valid Date – Days. Other Two Parameter Are Optional. This Function Returns The Working Day For The The Future Or The Past Dates.
SYNTAX: =WORKDAY.INTL (START_DATE, DAYS, [WEEKEND], [HOLIDAYS])
Weekend Parameters Is Optional But By Default It Is Set As (Sat-Sun). There Are Many Weekend Days Option Available To Set According To Your Country Based Or Requirement And Those Days Will Be Excluded While Calculating The Working Days.
Holidays Parameter Is Optional But If You Set Any Date It Will Be Considered As Holiday. It Will Be Excluded While Calculating The Working Days. Use (+) Number As Days For Future Dates And (-) Number For Past Dates.
Set Weekend Number | Weekends Days |
---|---|
1 | Saturday – Sunday |
2 | Sunday – Monday |
3 | Monday – Tuesday |
4 | Tuesday – Wednesday |
5 | Wednesday – Thursday |
6 | Thursday – Friday |
7 | Friday – Saturday |
11 | Sunday Only |
12 | Monday Only |
13 | Tuesday Only |
14 | Wednesday Only |
15 | Thursday Only |
16 | Friday Only |
17 | Saturday Only |