Date Day Assistance

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.

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

[email protected]
[email protected] with @tiscali.co.uk


"inspirz" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>