| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the occurrences of a month in a date&time cell
Hi,
I'm trying to count the occurrences of any given month in a rage where the cells are in a date&time format. (11/02/2008 11:22:53) For example in the range A1:A30 I want to count the number of times the month of February occurs. I've tried a count(if(mid formula but my brain melted after the 10 attempt. Any help would be greatly appreciated. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurrences of text within a cell | Excel Worksheet Functions | |||
| Counting occurrences of specific month | Excel Discussion (Misc queries) | |||
| Extra month shown in date count | Excel Worksheet Functions | |||
| Count how many persons in a month using a date | Excel Worksheet Functions | |||
| how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Threaded Mode
