Conditional modifiers for Date AND Time

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE 1600 on a Sunday, then I want a specific value displayed. I’ve read plenty of forums on conditional dates and conditional times, but I have seen nothing integrating the two. Here’s what I have:

‘=IF(((WEEKDAY(TODAY(),3)>=5)*AND(A5>=(TIME(16,0,0)))*AND((WEEKDAY(TODAY(),3)<=7)*AND(A5<=TIME(16,0,0))),6,0)

Where A5 is meant to be a cell with the current time. I know it looks messy. Am I way out of line here?

Thanks for any help!

By: Gerald

Leave a Reply

Your email address will not be published. Required fields are marked *