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

26 thoughts on “Conditional modifiers for Date AND Time

  1. suba suba

    lQ0XzH I simply could not depart your website before suggesting that I extremely enjoyed the usual information an individual provide to your visitors? Is gonna be again continuously to check out new posts.

  2. informatika

    Wow, fantastic blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, as well as the content!

  3. bathtubs doors

    Wow, incredible blog structure! How lengthy have you been running a blog for? you made blogging glance easy. The full glance of your site is great, let alone the content!

  4. EyBkAvVQq

    Spot on with this write-up, I seriously think this web site needs much more attention. I all probably be returning to see more, thanks for the advice!

Leave a Reply

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