IF Timestamp meets certain criteria then...

Hi All,

I'm looking for help with a formula that will look at a list of timestamps and provide a "Yes" or "No" if the day and time meets certain criteria.

Example:

If timestamp is a Monday and time is >=4pm, then "Yes", "No"
If "" Tuesday and time is >=4pm, then "Yes", "No"
If "" Wednesday and time is >=4pm, then "Yes", "No"
If "" Thursday and time is >=4pm, then "Yes", "No"
If "" Friday and time is >=4pm, then "Yes", "No"
If "" Sunday and time is >=11am, then "Yes", "No"

Any help greatly appreciated.

Best,

Andrew

Brilliant thanks!
Worked like a dream

Where is Saturday ?

HTML Code: