Counting a date range

Julie · External Since: Apr 28, 2006 Posts: 98

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 · External Since: Jan 04, 2006 Posts: 2988

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.RemoveThis@austin.rr.com
"Julie" <Julie.RemoveThis@discussions.microsoft.com> wrote in message
news:6FF0750C-0FDD-414D-BF4E-B550A8C3B4C6@microsoft.com...
> 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?

Max · External Since: Mar 17, 2004 Posts: 1751

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?