Fill Adjacent Cell with 0-30/30+/60+/90+ Past Due based on Dates in Column

[Excelrookie01]

Good morning, quite a lot of helpful information on this site for someone who is new to Excel. I have read through several threads trying to figure out a problem I've had for 3 days now. I'm going to do my best to describe it for anyone who is willing to help.

I have a column of dates in 'A'. In the 'B' column, I used =NOW()-A1 to get how many days the dates are past due. I'm trying to get the 'C' column populated with one of four options: item is either 0-30 past due, 30+ past due, 60+ past due or 90+ past due. Right now, I look at column 'B' and manually type the value in column 'C', so using the first date, the item is 30 days or more past due, but not yet 60+ days past due.

Example:
Due Date | Days Past Due | 0-30/30+/60+/90+
3/15/2017 | 55 | 30+
4/1/2017 | 38 | 30+
12/30/2016 | 130 | 90+
4/12/2017 | 27 | 0-30

Is there a way to use a formula to populate column 'C' based on column 'B' in my example above? The answer would help me immensely as the date list is growing longer each week. Thank you again to all the forum members for such a great place to find answers.

[kev_]

Welcome to the forum
In C2 copy down

Please Login or Register  to view this content.

[Excelrookie01]

Hi Kev,

Thank you so much! I'll give that a try right now.

[Glenn Kennedy]

One way (you can dispense with column B, if you wish):

=LOOKUP(TODAY()-A2,{0,30,60,90},{"0-30 past due","30+ past due","60+ past due","90+ past due"})

[Excelrookie01]

You both are amazing. I was able to make both solutions work. Record time solving a problem or maybe I'm just too new to Excel at the moment!

Sincerely, thank you!

[kev_]

Have you looked at conditional formatting? - you also could colour code your debts based on your 4 categories to make the bad ones stand out more

[Excelrookie01]

I have and I was able to do that fairly easily. These dates are actually action items that were supposed to be taken care of, so it's not a bookkeeping/financial scenario.

[Glenn Kennedy]

You're welcome, and thanks for the Rep.

It's only easy if you know what to do....