What a silly question !

[Guest]

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

 

[NickHK]

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

 

[tony h]

I would guess that you have A1 as a string "Monday" rather than a date
which is a monday. try putting 31-aug-2006 in A1

regards

 

[Niek Otten]

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

| 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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[NickHK]

Tom,
Use Niek's option then.

NickHK

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