Thank you so much for looking at this, attached is a simple sheet with data.
My formula is in G1
I want the user to be able to enter a single date, this is cell G2
The formula checks all dates in column C and considers all dates less then the user entered date as true
The formula also checks column D and considers all dates greater then the user date as true
The formula also checks if there is a blank cell in column D and would return that as true
In the sample data the correct answer should be 2
|