| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count dates in a column between 2 dates
Here is another formula:
=SUMPRODUCT(($AL$1000:$AL$5000<=TODAY())*($AL$1000 :$AL $5000=EDATE(TODAY(),-3))) Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count dates if few duplicates in a column | Excel Discussion (Misc queries) | |||
| count dates in a column | Excel Worksheet Functions | |||
| How to Count Months in a Column of Dates | Excel Programming | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Count cells in a column that contain dates | New Users to Excel | |||
Threaded Mode
