To this result, we add 1, which results in the first day of the next month.
The WORKDAY function automatically steps back 1 day, taking into account any weekends.
The result is the last workday of the month.
If you should probably customize weekend days, you might use theWEEKDAY.INTLfunction.
By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.
you could use the WEEKDAY function inside other formulas to check the day of week.
Use a positive value for months to move forward in time, and a negative number…
