Recognizing date range

Hello everyone!
So here is my question:
Is it possible to use or formula or else to recognize a date range?
Let me explain: I would like to know if an operation forecasted happened or no, but here is my issue. The operation may have been predicted yet since the exact date might differ using detection of duplicate won’t help. Finding a duplicate among a date range, I think is the way to go.
Hope it makes sense, any advice would be helpful!
Have a great day!