Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
based on the subject, i have a column that contains text and dates. i need to
count how many items fall on a certain month in a certain year. all dates are not stored as text values and the column contains blank cells too. for example: Colum D 10/05/05 10/06/05 11/01/05 10/05/04 (blank cell) 11/10/05 i need the output to look like this: Month:Oct Year:2004 = 1 Month:Nov Year:2004 = 0 Month:Oct Year:2005 = 2 Month:Nov YEar:2005 = 2 help on this will greatly be appreciated! thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
sort dates by day then month, not by year. | Excel Worksheet Functions | |||
Get count of records for a particular month and year | Excel Discussion (Misc queries) | |||
Count based on another column | Excel Discussion (Misc queries) | |||
COUNT IF COLUMN X="" COUNT COLUMN Y? | Excel Discussion (Misc queries) |