How do I count the number of records within a date range? New issu

[Guest]

My employer provides a database that I converted to excel with the following
values for dates... example... 01/01/2006.

I need some help to build a formula to count the namber of cells that fall
within a range of dates... for example 01/01/1955 to 12/31/1977. How do I do
this? I've tried lots of ideas... nothing seems to work for me.

 

[Roger Govier]

Hi Larry

There are many ways to achieve this.
It is probably easiest to put the date ranges in cells e.g. enter in D1
01/01/1955 and in E1 12/31/1977

Then with your range of dates being in column A
=COUNTIF(A:A,">="&D1)-COUNTIF(A:A,">"&E1)
This counts all the cells which have dates greater tna or equal to the
first date, and subtracts the number that are greater than the last date

Alternatively
=SUMPRODUCT(($A$1:$A$1000>=D1)*($A$1:$A$1000<=E1))
Note that you cannot use whole columns ranges with Sumproduct, just set
the range long enough to cover your set of data.