Picking out old dates

[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

 

[Peo Sjoblom]

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 ****

 

[Connie]

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

 

[Peo Sjoblom]

My Pleasure.

--

Regards,

Peo Sjoblom

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