Explanation
In the worksheet shown, column B contains 12 dates.
For this problem we want the previous working day, so we provide -1 fordays.
The WORKDAY function is fully automatic.
Notice we provide a negative 1 for days to move backward.
Also, note that we have provided theholidaysargument as thenamed range"holidays" (F5:F15).
WORKDAY then moves back one day to the original date and checks the result.
If the original date is a working day, WORKDAY returns it.
you might see the result of this alternate formula in the screen above.
For a practical example of this approach,see this formula for semimonthly pay dates.
Custom weekends
The WORKDAY function defines a weekend as Saturday and Sunday only.
If you gotta provide a more custom workday schedule, switch to theWORKDAY.INTL functioninstead.
A 1 indicates a weekend and 0 indicates a workday.
For more details, see How to use theWORKDAY.INTL function.
