Counting number of occurrences of a date
Posted by Jennifer on August 17, 2001 3:33 PM
I have a column of dates spanning over several years (format MM/DD/YY). What I'm trying to do is calculate how many times an occurrence happens in a month.
Like, how many entries I have for January 2001, February 2001, April 2002, etc.
I've tried using the COUNTIF function, and I can get it to calculate how many entries I have AFTER 01/01/01, but how can I have it to calculate how many entries i have between 1/01 and 1/31/01?
That way I can make a simple graph showing how many times things happened in a month.
Please email all responses to email@example.com