Finding the Number of Fridays in a Month

[Jack_Coley]

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?

[corb1 · Accepted solution]

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.