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!