This worked! Sorry I had been out of the office for a while. Thank you so much!

"Bob Phillips" wrote:

Assuming that the dates are in A1:A100

A101: =COUNTIF($A$1:$A$10,"<"&(TODAY()-120))
A102: =COUNTIF($A$1:$A$10,"<"&(TODAY()-90))-A101
A103: =COUNTIF($A$1:$A$10,"<"&(TODAY()-60))-A101-A102
A104: =COUNTIF($A$1:$A$10,"<"&(TODAY()-30))-A101-A102-A103

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Luey" wrote in message
...
Neither of the suggestions are working. Maybe I am asking the wrong
question?
I have a column of dates. Below that I want in 4 different squares a count
of
which of these dates is over 30, 60,90 and 120 days older than today's
date.

"Luey" wrote:

How do I figure which in a column are 30+, 60+, etc over today's date?