Formula to see a date as the day not the date

[Dazzybeeguy]

If I have a date in column A and custom formatting in column B to show the day, I want a formula in column C recognise if its a Weekend day and if so return the value of Main shift, if not a Saturday or Sunday to return Early Shift.

I tried to see if a formula would recognise a sunday

=IF(B2="Sunday","Sunday Shift","Early Shift")

but it doesnt work as it sees column B as a date not a day even thought it shows the day.

25/08/2024

Sunday

Early Shift

 

[arthurbr]

Try

=IF(WEEKDAY(A2,2)=7,"Sunday Shift","Early Shift")