What a silly question !
Hi Nick and Simon,
Thanks very much for the indication.
However in A1, we must introduce the day in text as: "Monday",
"Tuesday",..."Friday".
and then in A2, we should test whether we are during the week, or it is the
weekend.
Thanks a lot
Tom
"Simon Cleal" wrote:
It doesn't work becuase "Monday" is text not a date serial number
If you put 22/08/2006 in A1 then it will work
Alternativly you could use =IF(LEFT(A1,1)="S","Weekend","Week")
HTH
Simon
"tom" wrote:
Hi everyone,
I am facing the following situation:
A1= Monday;
A2=if(weekday(A1,2)<6,"Week","Weekend")
in A2, we should have: "Week", if the content of A1= Monday,
Tuesday,...Friday.
Or "Weekend", if the content of A1: Saturday or Sunday.
It doesn't work ! Why ?
Please help me !
Thanks very much
Tom
|