Hi

You could use
=IF(WEEKDAY(B1,2)5,"Off","Morning")

--
Regards
Roger Govier

"TFMR" wrote in message
...
Dear All,

I have time sheet, which have Date and day columns in day column I gave
the
ref. to A1 and change the format to "DDD", It shows the day e.g. Mon or
Tue.
Now I want to apply formula that if b1="Sat" or "Sun" then return Off in
c1
otherwise Morning in C1, but I am getting Morning in all cells.
Kindly advise what I have to mention in formula instead of Sat.
formula in C1 is "=if(b1="Sat"."Off",if(b1="Sun","Off","Morning "))
I tried full day but same result.

Thanks