Tom,
If you read the help on WEEKDAY, you will see it "Returns the day of the
week corresponding to a date".
So you have to pass a date (Now(), "01/12/06" etc).

NickHK

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