I have dates in the given columns like this:
Column: A2 - 5/29/2016
C2 - 2/15/2016
E2 - 1/25/2016
G2 - 4/1/2016
I need a count in a new cell maybe (H2) of all the dates which are less than 3/25/2016. Thus, in this case I should get "2" as my output.
What query I can use here? The date format in my data is mm/dd/yyyy
Thanks in advance for your help.
AOG.
Bookmarks