Count records within a date range

[brad_lucas]

Hi all,

In column A I have a list of dates (dd/mm/yyyy). What I am trying to do is count the number of records within that column that match a date range criteria. For example: How many records are listed between 14/11/2005 and 18/11/2005 (in my case there's 12).

Can anyone offer some advice?

Regards
Brad

 

[Peter_SSs]

brad_lucas

Welcome to the Mr Excel board!

Assuming that your dates are real dates and not text, try this.

I have put the dates of interest in B2 and C2. Formula in D2 is:
=COUNTIF(A1:A20,"<"&C2)-COUNTIF(A1:A20,"<="&B2)

If this does not give the result you expect, it could be my interpretation of 'between' two dates. In this case a slight adjust ment of the 'less than' and 'less than or equal to' symbols might be required.

Mr Excel.xls
	A	B	C	D
1	10/11/2005	Date 1	Date 2	Number
2	11/11/2005	14/11/2005	18/11/2005	5
3	12/11/2005
4	13/11/2005
5	14/11/2005
6	15/11/2005
7	15/11/2005
8	16/11/2005
9	16/11/2005
10	17/11/2005
11	18/11/2005
12	19/11/2005
13	20/11/2005
Count Dates

 

[brad_lucas]

Many thanks, Peter,

You're spot on. That is exactly what I needed.

Regards
Brad