Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting in between a date range with conditions | Excel Discussion (Misc queries) | |||
Counting items within a date range | New Users to Excel | |||
Counting Within a Date Range | Excel Worksheet Functions | |||
Counting if between date range | Excel Worksheet Functions | |||
Counting values within a Date Range | Excel Discussion (Misc queries) |