software

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)lt;3,B1,quot;quot;))

This will return a blank if it's Wed-Fri....Replace the quot;quot; with your
alternate result.--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=538639This 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)gt;5,B2,B1)

Will return B2 for Saturday amp; Sunday amp; B1 for all other days

--
HTH

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.ukquot;inspirzquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Problem:
gt;
gt; Cell A1: Date (3/1/05) - Which is Thursday.
gt; Cell B1: 4:00 am
gt; Cell B2: 6:00 am
gt;
gt; What I want:
gt; I want a if statement that says - If A1 = Saturday or Sunday = Cell B2
gt; (06:00 am) but if not then cell B1 (4:00 am). Basically all I want is if
gt; it's
gt; MOnday to Tuesday it's 4:00 am and if Saturday or Sunday 06:00 am.
gt;
gt; Thanks,
gt; Mike
gt;
gt;