Hi,
I'm having a bit of a moment. I'll kick myself when you say the solution. Example attached.
I have 3 columns of data - Start Date, End Date, Deadline.
To get the info I want I have a fourth column titled "month" which I use for the criteria. From this I want to find out two things.
1. How many End Dates fall in that "month" which I've done (Columne F)
2. How many of those End Dates were equal to or less than the deadline column (yellow in example - column G)
Thanks for any help
Bookmarks