Excel: counting cells which have dates between specified dates

[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

 

[Guest]

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

Obviously adjust your range to suit your data

Suddes

 

[Bob Phillips]

Jacqueline,

Your example did not match your question, so Suddess answer may or may not
be appropriate.

If you want to test between dates, use

=SUMPRODUCT(--(A1:A100>=--"2004/01/01"),--(A1:A100<=--"2004/09/01"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)