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:


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 *