I am a novice Excel use, and I have a question about where this is even possible. I have a column of dates and I want to count the number of times a month AND year appear in a single cell.
For example:
A1= January 2, 2007
A2= January 14, 2007
A3= February 21, 2007
A4= May 10, 2007
A5= January 19, 2008
A6= April 16, 2008
Is it possible to use a COUNTIF formula to make Excel count the number of times "January" AND "2007" appear together in a cell, so that I can get the number of times in the month of January 2007 a certain event occurred. I'm logging bird sightings for a study, and I need to know the frequency of sightings per month per year.
