days+30
 

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

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)


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

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

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

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" wrote:

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)


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

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)


"Luey" wrote in message
...
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" wrote:

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)


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

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?

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?

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?