checking two conditions

  • Thread starter Thread starter Tmian
  • Start date Start date
T

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
 
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
Click to expand...
 
=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)
 
Back
Top