| 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) | |||
Linear Mode
