Home |
Search |
Today's Posts |
#1
|
|||
|
|||
days+30
How do I figure which in a column are 30+, 60+, etc over today's date?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? . |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
#8
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Days in Calender | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |