| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting the dates in a column
Hi All,
At present I have a formula that counts the number of date entries in a column. =COUNT($AL$1000:$AL$5000,"<=today()") I need to change it so that it counts the dates between today and the last 3 months. Can someone tell me how, I have tried all manner of configurations. Many thanks Joe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting the dates in a column
Firstly, if you want to apply a condition you need COUNTIF(), not COUNT()
Secondly, the condition "<=today()" won't work, you'll need ,"<="&today() Thirdly, you can test for <= TODAY(), and then subtract those <= three months ago to get those between, so try =COUNTIF($AL$1000:$AL$5000,"<="&TODAY()) -COUNTIF($AL$1000:$AL$5000,"<="&DATE(YEAR(TODAY()), MONTH(TODAY())-3,DAY(TODAY()))) -- David Biddulph "deaconj999" wrote in message ups.com... Hi All, At present I have a formula that counts the number of date entries in a column. =COUNT($AL$1000:$AL$5000,"<=today()") I need to change it so that it counts the dates between today and the last 3 months. Can someone tell me how, I have tried all manner of configurations. Many thanks Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max of % nembers in column WITHOUT counting dates | Excel Worksheet Functions | |||
| counting occasions dates occur between 2 dates | New Users to Excel | |||
| counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| Counting dates in a column | Excel Worksheet Functions | |||
Linear Mode
