Picking out old dates

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

What formula would I use for this?

If M5 is more than one month but less than six months from
current date, put a * in N5; if M5 is more than 6 months
but less than 12 months from current date, put ** in N5;
if M5 is more than 12 months but less than 18 months from
current date, put *** in N5; if M5 is more than 18 months
but less from 24 months from current date, put **** in N5.

"otherwise leave blank" would be at the end of each IF
statement

I can get some of it figured out but I'm missing something.

Thank you. Connie
 
One way

=IF(OR(DATEDIF(M5,TODAY(),"m")<1,DATEDIF(M5,TODAY(),"m")>=24),"",VLOOKUP(DAT
EDIF(M5,TODAY(),"m"),{1,"*";6,"**";12,"***";18,"****"},2))

change the >=24 to >24 if you want to include 24 months for ****
 
This works! Thank you so much! With a worksheet of over
300 rows and a great conglomeration of dates, this save a
lot of work. Thanks again!

Connie
 
My Pleasure.

--

Regards,

Peo Sjoblom


Connie said:
This works! Thank you so much! With a worksheet of over
300 rows and a great conglomeration of dates, this save a
lot of work. Thanks again!

Connie
Click to expand...
 
Back
Top