Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how get many days in March repeate in column have many dates
i have a cloumn have many dates. i would like to know how many days repeated
in january, February and March for example |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how get many days in March repeate in column have many dates
This counts the number of repeated items for March
=SUMPRODUCT(--(MONTH(A1:A20)=3))-SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&"")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Wael Adel" <Wael wrote in message ... i have a cloumn have many dates. i would like to know how many days repeated in january, February and March for example |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF for numbers of dates in column which are 30 days older than today | Excel Worksheet Functions | |||
Why does excel calculate difference in days from February - March | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
Calculate number of days in a column of dates | Excel Discussion (Misc queries) |