Counting a date range

[Julie]

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?

 

[Don Guillett]

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

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

 

[Max]

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