| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
count no. of dates in a column that falls on certain month & year
Ron Rosenfeld wrote...
.... Then in F1 enter the formula: =TEXT(E1,"""Month:""mmm ""Year:""yyyy"" = """)& COUNTIF($D$1:$D$6,"="&E1)-COUNTIF($D$1:$D$6, ""&DATE(YEAR(E1),MONTH(E1)+1,0)) .... Could be shortened a bit. =TEXT(E1,"""Month:""mmm ""Year:""yyyy = ")& SUMPRODUCT(--(TEXT($D$1:$D$6,"yyyymm")=TEXT(E1,"yyyymm"))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
| Get count of records for a particular month and year | Excel Discussion (Misc queries) | |||
| Count based on another column | Excel Discussion (Misc queries) | |||
| COUNT IF COLUMN X="" COUNT COLUMN Y? | Excel Discussion (Misc queries) | |||
Threaded Mode
