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?
Solved
Determine if WORKDAY() returns a Friday or Monday
+8Best answer by corb1
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.
+5You 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.