I have data that contains data with dates. Dates are in the format of 12/1/2004 etc. I want to make a countif statement to tell me many values fall in a particular month.. So here is what I am trying
=COUNTIF(data!K5:K1480,12/1/2004:12/31/2004)
Which doesnt work.. It will tell me what is on 12/1/2004 if I remove the :12/31/2004..
What is the method to specify a range in the criteria?
data!K5:K1480 is the page and column that I want to find the values of.
=COUNTIF(data!K5:K1480,12/1/2004:12/31/2004)
Which doesnt work.. It will tell me what is on 12/1/2004 if I remove the :12/31/2004..
What is the method to specify a range in the criteria?
data!K5:K1480 is the page and column that I want to find the values of.