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