if statment

[Stuntz Waldorf]

I have a cell (b1) formatted as ddd, d-mmm-yy and I need cell (a1) to show
"weekend" if the cell (b1) is a "Sat" or "Sun". What is the proper syntax for
this "IF" statement or is there a better way to accomplish this issue?

TIA

 

[NBVC]

Try:

=IF(LEFT(TEXT(B1,"ddd"))="S","WeekEnd","WeekDay")

 

[Gary Brown]

=IF(MOD(B2,7)<=1,"Weekend","")

 

[Stuntz Waldorf]

Works like a charm. Thank You for you immediate reply!!!!!!!!!!

 

[Bernard Liengme]

Alternative solution
=IF(=WEEKDAY(B1,2)>5,"Weekend","Weekday")
best wishes