| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cells in date range
Lets assume I have all my dates in one column (T). How can I count the
number of occurances I have per month. I want a count of all dates in Jan, Feb, etc. for that year. My data will be setup like this: A B C D 1/01/2006 2/01/2006..... 1/01/2007 2/01/2007.... 1 Count of Date |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cells in date range
=SUMPRODUCT(--(TEXT(A1:A100,"mmmyy")="Jan07"))
"Clay" wrote: Lets assume I have all my dates in one column (T). How can I count the number of occurances I have per month. I want a count of all dates in Jan, Feb, etc. for that year. My data will be setup like this: A B C D 1/01/2006 2/01/2006..... 1/01/2007 2/01/2007.... 1 Count of Date |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cells in date range
"Teethless mama" wrote: =SUMPRODUCT(--(TEXT(A1:A100,"mmmyy")="Jan07")) "Clay" wrote: Lets assume I have all my dates in one column (T). How can I count the number of occurances I have per month. I want a count of all dates in Jan, Feb, etc. for that year. My data will be setup like this: A B C D 1/01/2006 2/01/2006..... 1/01/2007 2/01/2007.... 1 Count of Date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells within a date range | Excel Discussion (Misc queries) | |||
| Easy way to count cells within date range | Excel Discussion (Misc queries) | |||
| Count cells between a date range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Linear Mode
