*sigh*

I regretted to provide information that the dates are formatted as
dd/mm/yyyy, so the formulas provided to me will not work.

Is there another way this can be done?

Sorry for the confusion.

Thank you.


"Bob Phillips" wrote:

Type

=COUNTIF(D1:D2500,1999)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"EdMac" wrote in
message ...

=COUNTIF(D1:D2500=1999) - use the year you want

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504479