| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count the occurances of a month in a range of date fields
I am needing to count the number of times each month is repeated in a column.
The column is a date field in MM/DD/YY format. I attempted to change the format to MMMM DD, YYYY format (e.g. January 1, 2005) and count off of the word January, but that did not work (=COUNTIF(C:C,"*January*")). Is there way to find out how many times a month is repeated? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count weekdays in a date range | Excel Worksheet Functions | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Threaded Mode
