days+30

B

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

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
 
L

Luey

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!
 
B

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

Luey

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.
 
B

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