| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count dates in a column between 2 dates
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.programming
|
|||
|
|||
|
How to count dates in a column between 2 dates
Give this a try: Watch for the word wraping below
=COUNTIF($AL$1000:$AL$5000,"<="&TODAY())-COUNTIF($AL$1000:$AL$5000,"<="&DATE(YEAR(TODAY()), MONTH(TODAY())-3,DAY(TODAY()))) HTH "deaconj999" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to count dates in a column between 2 dates
This may work
=COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()), MONTH(TODAY())-3,DAY(TODAY()))) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "deaconj999" wrote in message oups.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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to count dates in a column between 2 dates
If OP has Future Dates in Column A, wouldn't they also be included in the
count (He wanted to limit from 3 months back to today)? "Nick Hodge" wrote: This may work =COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()), MONTH(TODAY())-3,DAY(TODAY()))) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "deaconj999" wrote in message oups.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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to count dates in a column between 2 dates
Check your other posts, too.
deaconj999 wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to count dates in a column between 2 dates
Nick,
Sorry -- just forget what I just wrote - I just came back to look this over, and I'm not half-way sure what I said is right or not, I'm nearly brain-dead status.. Jim "Nick Hodge" wrote: This may work =COUNTIF($AL$1000:$AL$5000,"<"&DATE(YEAR(TODAY()), MONTH(TODAY())-3,DAY(TODAY()))) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "deaconj999" wrote in message oups.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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
