Thursday, November 21

WORKDAY.INTL Function To Extract Working Days

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 NumberWeekends Days
1Saturday – Sunday
2Sunday – Monday
3Monday – Tuesday
4Tuesday – Wednesday
5Wednesday – Thursday
6Thursday – Friday
7Friday – Saturday
11Sunday Only
12Monday Only
13Tuesday Only
14Wednesday Only
15Thursday Only
16Friday Only
17Saturday Only

Leave a Reply

Your email address will not be published. Required fields are marked *