Help

Determine if WORKDAY() returns a Friday or Monday

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
382 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jack_Coley
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
corb1
6 - Interface Innovator
6 - Interface Innovator

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.

See Solution in Thread

1 Reply 1
corb1
6 - Interface Innovator
6 - Interface Innovator

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.