View Single Post
 
Old 10-16-2019, 09:27 AM
ShostyFan ShostyFan is offline Windows 10 Office 2007
Novice
 
Join Date: Oct 2019
Posts: 4
ShostyFan is on a distinguished road
Default

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
Attached Files
File Type: xlsx DateCountHelp.xlsx (250.3 KB, 8 views)
Reply With Quote