ExcelBanter - Count date occurences within a year

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count date occurences within a year (https://www.excelbanter.com/excel-discussion-misc-queries/176342-count-date-occurences-within-year.html)

LOU

Count date occurences within a year

I have a column containing specific dates on which an event occurred and am
trying to create a formula that counts how many dates fall within a given
year. Any help is appreciated.

T. Valko

Count date occurences within a year

This formula will count all dates in the range that are in the year 2007:

=SUMPRODUCT(--(YEAR(A1:A10)=2007))

--
Biff
Microsoft Excel MVP

"Lou" wrote in message
...
I have a column containing specific dates on which an event occurred and am
trying to create a formula that counts how many dates fall within a given
year. Any help is appreciated.

All times are GMT +1. The time now is 04:44 AM.