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 Days1Saturday - Sunday2Sunday - Monday3Monday - Tuesday4Tuesda...