count between dates

[Doug Loewen]

I have a table with a column of dates from the years 2001
to 2005. The cells are formatted as 5-Jul-04. Is there a
formula I can use to search the column and count all the
dates in a given year, i.e. 10 dates in 2004.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(YEAR(A1:A1000)=2004))

 

[Ron Rosenfeld]

I have a table with a column of dates from the years 2001
to 2005. The cells are formatted as 5-Jul-04. Is there a
formula I can use to search the column and count all the
dates in a given year, i.e. 10 dates in 2004.

If the dates are in column A:

=COUNTIF(A:A,">"&DATE(2004,1,0))-COUNTIF(A:A,">"&DATE(2004,12,31))


--ron