Good Day;
I am trying to figure out how to count the number of Events that have occurred for each month in a year and then place that number into another table which then gets graphed. This will cover five (5) years so I would like an easier way than what I have kluged together.
The only way I have been able to get it to work is to use a COUNTIF formula but I have to first convert the year and month I am interested from a date value (yyyy-mm) to a numerical date value and then manually enter those numerical date values into the COUNTIF formula.
This is my COUNTIF formula that I am using: =COUNTIFS($C$2:$C$23,">=41640",$C$2:$C$23,"<41671")
$C$2:$C$23 is the range of dates (in Date format yyyy-mm-dd).
41640 is 01 Jan 2014 in numerical date value.
41671 is 01 Feb 2014 in numerical date value.
Any ideas how I might do this?
I have attached my spreadsheet so you have a good idea of what I am trying to do.
Thanks for the help.
Kevin
I am trying to figure out how to count the number of Events that have occurred for each month in a year and then place that number into another table which then gets graphed. This will cover five (5) years so I would like an easier way than what I have kluged together.
The only way I have been able to get it to work is to use a COUNTIF formula but I have to first convert the year and month I am interested from a date value (yyyy-mm) to a numerical date value and then manually enter those numerical date values into the COUNTIF formula.
This is my COUNTIF formula that I am using: =COUNTIFS($C$2:$C$23,">=41640",$C$2:$C$23,"<41671")
$C$2:$C$23 is the range of dates (in Date format yyyy-mm-dd).
41640 is 01 Jan 2014 in numerical date value.
41671 is 01 Feb 2014 in numerical date value.
Any ideas how I might do this?
I have attached my spreadsheet so you have a good idea of what I am trying to do.
Thanks for the help.
Kevin