Formula to show months

[Hazeyt]

Please can anyone help with a formula?

I have a list of Valid Until dates for mandatory work courses.

I want the formula to show if the valid until date is a month away from today's date then put "1 month" in column, if 2 months, then show "2 months", any months over 2 months then, show "> 3 months".

Thanks

 

[Joe4]

If it is 15 days away, should it return a 1?

Let's say the date is in cell A1. Then you could use a formula like:

=IF(TODAY()-A1>60,">3 months",IF(TODAY()-A1>30,"2 months",IF(TODAY()-A1>0,"1 month","")))

Note I am returning:
- "3 months" for greater than 60 days
- "2 months" for greater than 30 days
- "1 month" for greater than 0 days

Adjust the formula to suit your needs.

 

[Hazeyt]

If it is 15 days away, should it return a 1?

Let's say the date is in cell A1. Then you could use a formula like:

=IF(TODAY()-A1>60,">3 months",IF(TODAY()-A1>30,"2 months",IF(TODAY()-A1>0,"1 month","")))

Note I am returning:
- "3 months" for greater than 60 days
- "2 months" for greater than 30 days
- "1 month" for greater than 0 days

Adjust the formula to suit your needs.

Thank you

 

[Joe4]

You are welcome.
Glad I was able to help!