Thread: How do I count the number of records within a date range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I count the number of records within a date range
=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
Reply With QuoteReply With Quote