I have the formula below which states that if NOW is greater than the
Time in B1 (which is 3:00pm) then return NOW, oherwise return 3pm.

=IF(NOW()B1,NOW(),B1)

How would I construct a formula that says if the days is any day other
than Tuesday or Wednesday, then use the formula above, but if it is
Tuesday or Wednesday, then B1 should be 8:00pm?

Thanks

Not sure exactly what you wanted but try this
=IF(WEEKDAY(NOW())=2,"8:00 p.m.",IF(WEEKDAY(NOW())=3,"8:00
p.m.",IF(NOW()B1,NOW(),B1)))

if you want to check just in B1 change my now() to B1
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Sean" wrote:

I have the formula below which states that if NOW is greater than the
Time in B1 (which is 3:00pm) then return NOW, oherwise return 3pm.

=IF(NOW()B1,NOW(),B1)

How would I construct a formula that says if the days is any day other
than Tuesday or Wednesday, then use the formula above, but if it is
Tuesday or Wednesday, then B1 should be 8:00pm?

Thanks

On Feb 3, 10:51 am, John Bundy (remove) wrote:
Not sure exactly what you wanted but try this
=IF(WEEKDAY(NOW())=2,"8:00 p.m.",IF(WEEKDAY(NOW())=3,"8:00
p.m.",IF(NOW()B1,NOW(),B1)))

if you want to check just in B1 change my now() to B1
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.



Thanks John, took me a while to work out that Sunday = 1


"Sean" wrote:
I have the formula below which states that if NOW is greater than the
Time in B1 (which is 3:00pm) then return NOW, oherwise return 3pm.

=IF(NOW()B1,NOW(),B1)

How would I construct a formula that says if the days is any day other
than Tuesday or Wednesday, then use the formula above, but if it is
Tuesday or Wednesday, then B1 should be 8:00pm?

Thanks- Hide quoted text -

- Show quoted text -

Perhaps this, in say, C1:
=IF(OR(WEEKDAY(TODAY())<{2,3}),MAX(NOW(),B1),MAX( NOW(),TIME(20,0,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote in message
ups.com...
I have the formula below which states that if NOW is greater than the
Time in B1 (which is 3:00pm) then return NOW, oherwise return 3pm.

=IF(NOW()B1,NOW(),B1)

How would I construct a formula that says if the days is any day other
than Tuesday or Wednesday, then use the formula above, but if it is
Tuesday or Wednesday, then B1 should be 8:00pm?

Thanks

Format C1 as: h:mm AM/PM
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---