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