Explanation
In the worksheet shown, column B contains 12 dates.
For this problem we want the next working day, so we provide 1 fordays.
The WORKDAY function is fully automatic.
Given a valid date, it will add days to the date, skipping weekends and holidays.
Named ranges behave likeabsolute referencesby default so the range will not change as the formula is copied down.
WORKDAY then moves forward one day to the original date and checks the result.
If the original date is a working day, WORKDAY returns the date unchanged.
it’s possible for you to see the result in the worksheet above.
Custom weekends
The WORKDAY function defines a weekend as Saturday and Sunday only.
In this scheme, a 1 indicates a weekend and a 0 indicates a workday.
For more details, see How to use theWORKDAY.INTL function.
