if statment
=IF(MOD(B2,7)<=1,"Weekend","")
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
"Stuntz Waldorf" wrote:
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
|