Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the occurance of a particular month in a column of dates
I'm having no luck getting a total count of the number of times a particular
month is present in a date column. This is what I've been trying to get a count of the number of dates that fall in the month of July, regardless of the year: =COUNT(MONTH(I$1:I286),7) Can anyone help me solve this little problem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurance of a month in a column of dates? | Excel Worksheet Functions | |||
count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
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 |