days+30

[Guest]

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

 

[Bob Phillips]

In adjacent column

=IF(A1>=TODAY()+60,"60+",IF(A1>=TODAY()+30,"30+",""))

and copy down

--

HTH

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

 

[Jason Morin]

With dates in col. A, try this in col. B:

=LOOKUP(FLOOR(MAX(TODAY()-A1,0),30),{0,30,60,90,120},
{"","30+","60+","90+","120+"})

HTH
Jason
Atlanta, GA

 

[Guest]

And if I want to do a whole column I would put
=IF(A1.A50>=TODAY()+60,"60+",IF(A1>=TODAY()+30,"30+","")) ? Thank you so
much for your help!

 

[Bob Phillips]

NO, put what I gave you in the first cell of the column and copy down.

--

HTH

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

 

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

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