This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm using the WORKDAY function and it's skipping the weekend as it should, but it always returns the previous Friday. Is there a way to have it return Friday if the date falls on a Saturday, and return Monday if it falls on Sunday?
You would want to use the WEEKDAY() function to check the conditions you describe. If weekday = Saturday, then do A. If Sunday then B. If other, then C.
You would want to use the WEEKDAY() function to check the conditions you describe. If weekday = Saturday, then do A. If Sunday then B. If other, then C.