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