Hello -
I have a spreadsheet with a date column that has about 10,000 dates (format dd/mm/yyyy) over the course of 3 years. I am looking for a formula that counts the number of entries by month/year (ie, the number of entries that fall in March, 2013.)
I have attached an example spreadsheet. The entries I need to count is in column N. You can see the table I developed and the formula I was trying to use:
=SUMPRODUCT(--(ISNUMBER(S$2:$S$50)),(MONTH($S$2:$S$50)=(MONTH(M53))))
Bookmarks