Hi Niek,

Yes it works !!!

thanks very much for the indication and your kind help.
Thanks very much also to all those who tried to help me.
regards
Tom



"Niek Otten" wrote:

Hi Tom,

Your method assumes you have a real Excel date in A1.
If you have text like "Monday":

=IF(OR(A1="Sunday",A1="Saturday"),"weekend","week" )

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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