Count rows if date is between two specified dates
 

Hi

I have a worksheet that has one column containing dates (D3:D1400)

In another cell I want to count the number of rows that have a date between
two specified dates, eg. 01/10/05 and 31/10/05.

Anyone got any idea how I would achieve this? Any help would be very much
appreciated.

Kind Regards

John

Count rows if date is between two specified dates
 

sometimes I use this formula (may be more elgant soltuions are available)

=SUMPRODUCT((A2:A2038620)*(A2:A20<38670))

the criteria dates are converted to serial number of dates.
==================

"mg_sv_r" wrote in message
...
Hi

I have a worksheet that has one column containing dates (D3:D1400)

In another cell I want to count the number of rows that have a date
between
two specified dates, eg. 01/10/05 and 31/10/05.

Anyone got any idea how I would achieve this? Any help would be very much
appreciated.

Kind Regards

John