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?
|