This worked a treat as I am not using USA style - thank you - Mike

"Chip Pearson" wrote:

"Teethless mama" wrote in message
=COUNTIF(A1:A100,"="&"1/1/2003")-COUNTIF(A1:A100,""&"12/31/2003")

This may cause problems in locales that use non-USA date styles. Better to
use the DATE function to create the dates.

=COUNTIF(A1:A20,"<"&DATE(2006,12,31))-COUNTIF(A1:A20,"<"&DATE(2006,1,1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Teethless mama" wrote in message
...
=COUNTIF(A1:A100,"="&"1/1/2003")-COUNTIF(A1:A100,""&"12/31/2003")

Format cell as General


"Mike" wrote:

How do I count the number of records within a date range.
eg 1/1/2003,1/5/2003,1/10/2004 Using countif between 1/1/2003 and
31/12/2003
= 2