Excel: counting cells which have dates between specified dates

J

Jacqueline

Hello,

I hope you can help me.

I would like to be able to count the number of cells which have date
between specified dates, for example

count the number of cells where the date is in the year 2002
the data in the column is currently in the form dd/mm/yy.

Thank you for anyone's help in this,

Have a good day.

Jacquelin
 
S

Suddes

How doos
try
=SUMPRODUCT(--(YEAR(A1:A100)=2002))

Obviously adjust your range to suit your data

Suddes
 
Top