checking two conditions

[Tmian]

Hi all.
I have a little problem and hope someone can help.

I want to check if a cell contains Saturday or Sunday. If it does
want to use the value in B1 otherwise use the value in B2.

I have a list of the days of the week relative to the dates using:

=TEXT(WEEKDAY(B17),"dddd")

Where B17 contains a date.

Thank you in advance,

Jas

 

[Trevor Shuttleworth]

=IF(OR(WEEKDAY(B17)=1,WEEKDAY(B17)=7),B1,B2)

Regards

Trevor

 

[RagDyer]

Try this:

=IF(OR(TEXT(WEEKDAY(B17),"dddd")={"Saturday","Sunday"}),B1,B2)

 

[Dave Peterson]

One more:

=IF(WEEKDAY(B17,2)>5,B1,B2)

Hi all.
I have a little problem and hope someone can help.

I want to check if a cell contains Saturday or Sunday. If it does I
want to use the value in B1 otherwise use the value in B2.

I have a list of the days of the week relative to the dates using:

=TEXT(WEEKDAY(B17),"dddd")

Where B17 contains a date.

Thank you in advance,

Jase

 

[Tmian]

Thanks very much.
It worked a treat.

Take care.

Jase

 

[Bob Phillips]

=IF(LEFT(C17)="S",B1,B2)

assuming that formula is in C17

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)