| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurance of a month in a column of dates?
In Excel I'm trying to count the number of times a given month occurs in a
column of values of the type date. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count occurance of a month in a column of dates?
=SUMPRODUCT(--(ISNUMBER(A2:A500)),--(MONTH(A2:A500)=2))
would count February =SUMPRODUCT(--(ISNUMBER(A2:A500)),--(YEAR(A2:A500)=2007),--(MONTH(A2:A500)=2)) would count February 2007 -- Regards, Peo Sjoblom "Stormy" wrote in message ... In Excel I'm trying to count the number of times a given month occurs in a column of values of the type date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
| Count occurance of largest duplicate number in a single column ran | New Users to Excel | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Excell: count occurance of letters in a column | Excel Worksheet Functions | |||
Linear Mode
