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.
