Alternative solution
=IF(=WEEKDAY(B1,2)5,"Weekend","Weekday")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Stuntz Waldorf" <Stuntz wrote in message
...
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