WORKDAY automatically excludes weekends (Saturday and Sunday) and can optionally exclude holidays.
WORKDAY accepts 3 arguments:start_date,days, and (optionally)holidays.
It always returns the original start date, even if it is a weekend or holiday.
Effectively, we are “tricking” WORKDAY into evaluating the original date as thestart_date.
If the date is a workday, it will remain unchanged.
Then we compare the original start date in cell B5 to the result of the WORKDAY function.
If the dates are the same (i.e.
This is the formula used in cell D5 of the worksheet shown above.
We do this because we want to shadenon-workdays.
Unlike the simplerWORKDAY function, WORKDAY.INTL can be…
