Forum Discussion

SGeorgie's avatar
SGeorgie
Brass Contributor
Dec 19, 2022
Solved

Calculating number of days overdue

Hi

 

I have a columns with number of days overdue, but i want a column to right of that to say if date is <14 to put "0-14 days", if between 15 -31 t o put "15-21 days", if over 22 put "22+ days" and then 30+ is "30+ days"

 

Any advice much appreciated

Sarah

excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Dec 19, 2022

    SGeorgie 

    Try this one:

    =VLOOKUP(T2,{0,"0-14 Days";15,"15-21 Days";22,"22+ Days";30,"30 + Days"},2)

     

     

  • SGeorgie's avatar
    SGeorgie
    Brass Contributor
    Dec 19, 2022
    Found this but says there is an error: (T2 is no. of days column =IF(AND(T2<14,"0-14days",IF(AND(T2>=15<=21,"15-21 days",IF(AND(T2>=22<=29,"21+ days",IF(AND(T2>=30,"30+ days"))))))))

Resources