Date Day Assistance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 you
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top