Counting the dates in a column

D

deaconj999

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
 
D

David Biddulph

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())))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count dates in a column between 2 dates 6
Excel formual to count dates in a column 3
counting dates using SUMPRODUCT 4
Help with counting between dates 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
COUNTIF-look for dates in range 4
Excel Help with dates 2
Counting dates before today 6

Top