Checking Dates

[Noxqss38242]

Need a formula to see if a date is in between 2 dates but with multiple ranges....

Example:

2/10/2009 10/12/2020
4/8/2021 8/20/2021
10/1/2021 10/17/2022
11/20/2022 4/15/2023


Then I have a date: 4/28/2021

I want a cell (let's say cell D4) to say "Valid" or "Invalid if the date 4/28/2021 falls within any of those ranges. In this case it would say "Valid"

If I had a date that said: 2/15/2021 It should show "Invalid" since that date doesn't fall within those ranges.

Not trying to complicate things, I just need a workable formula so I can adjust the cell data to match

Any suggestion?

 

[Noxqss38242]

=IF(COUNTIFS($C$3:$C$27,"<="&C33,$E$3:$E$27,">="&C33)>0,"YES","NO")