Hi,

Problem:

Cell A1: Date (3/1/05) - Which is Thursday.
Cell B1: 4:00 am
Cell B2: 6:00 am

What I want:
I want a if statement that says - If A1 = Saturday or Sunday = Cell B2
(06:00 am) but if not then cell B1 (4:00 am). Basically all I want is if it's
MOnday to Tuesday it's 4:00 am and if Saturday or Sunday 06:00 am.

Thanks,
Mike

Try:

=IF(OR(Weekday(A1)=1,Weekday(A1)=7),B2,B1)


or if you really want to identify Sat, Sun, Mon, Tues, then.
=IF(OR(Weekday(A1)=1,Weekday(A1)=7),B2,If(Weekday( A1)<3,B1,""))

This will return a blank if it's Wed-Fri....Replace the "" with your
alternate result.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=538639

This formula returns the value in B2 if the date in A1 is Saturday or
Sunday, and returns B1 on every other day:
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),B2,B1)

Try:

=IF(WEEKDAY(F11,2)5,B2,B1)

Will return B2 for Saturday & Sunday & B1 for all other days

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"inspirz" wrote in message
...
Hi,

Problem:

Cell A1: Date (3/1/05) - Which is Thursday.
Cell B1: 4:00 am
Cell B2: 6:00 am

What I want:
I want a if statement that says - If A1 = Saturday or Sunday = Cell B2
(06:00 am) but if not then cell B1 (4:00 am). Basically all I want is if
it's
MOnday to Tuesday it's 4:00 am and if Saturday or Sunday 06:00 am.

Thanks,
Mike