I thought this would be straight forward.

Column A is the date. Column B = Column A but in DDDD format. I want column C to give me a value based off column B.

If column B = "Saturday" or "Sunday" then column C is 8. If any other day, then 9.
My If/Or formula works if column B is just text, but if it's in DDDD format it won't work..

Sample file attached.

Workbook3.xlsx

Thanks for your help.
Rob