Thread: How do I count the number of records within a date range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default How do I count the number of records within a date range
try
=sumproduct((year(daterng)=2003)*1)

--
Don Guillett
SalesAid Software

"Mike" wrote in message
...
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


Reply With QuoteReply With Quote