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