Counting a date range
 

Hi. I'm used to operating in Access, but need to do some analysis in Excel
because my users don't have Access.

I have a worksheet called "Master" with a column called "Date of Referral".
I've created a new worksheet called "Analysis" and want to count all the
records for the month of October.

Any ideas?

Counting a date range
 

Assuming REAL dates in column A. Do not use a:a

=sumproduct((month(a2:a22)=10)*1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Julie" wrote in message
...
Hi. I'm used to operating in Access, but need to do some analysis in
Excel
because my users don't have Access.

I have a worksheet called "Master" with a column called "Date of
Referral".
I've created a new worksheet called "Analysis" and want to count all the
records for the month of October.

Any ideas?

Counting a date range
 

One way, in Analysis:
=SUMPRODUCT(--(TEXT(Master!A2:A100,"mmmyy")="Oct09"))
assuming dates of referral are in A2:A100, and are all real dates
any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Julie" wrote:
Hi. I'm used to operating in Access, but need to do some analysis in Excel
because my users don't have Access.

I have a worksheet called "Master" with a column called "Date of Referral".
I've created a new worksheet called "Analysis" and want to count all the
records for the month of October.

Any ideas?