"Between" dates in Excel
 

Hi,

I have a column of dates in a worksheet and I need to find how many dates
are between 2 dates specified (probably month / quater end dates).

In Access I would use the between command, but how can I do this in Excel?

"Between" dates in Excel
 

This example counts day in May 2007:-

=COUNTIF(A1:A100,"<="&DATE(2007,5,31))-COUNTIF(A1:A100,"<"&DATE(2007,5,1))

Mike

"Richie" wrote:

Hi,

I have a column of dates in a worksheet and I need to find how many dates
are between 2 dates specified (probably month / quater end dates).

In Access I would use the between command, but how can I do this in Excel?

"Between" dates in Excel
 

try
=sumproduct((a2:a22b1)*(a2:a22<=b2))

--
Don Guillett
SalesAid Software

"Richie" wrote in message
...
Hi,

I have a column of dates in a worksheet and I need to find how many dates
are between 2 dates specified (probably month / quater end dates).

In Access I would use the between command, but how can I do this in Excel?