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