hello friends,

could you please help with a date conditional formating issue

Valid to Dates Conditional Formating

30.10.2013 RED
2.01.2014 RED
30.08.2014 YELLOW
30.09.2013 no formatting Expired
31.12.9999 no formatting


The dates are in different format with dots in between as shown above
Also with respect to date which has already expired, no formatting needed but i need a formula in the next column stating "Expired"

If valid to date is within 90 days from today- RED
If valid to date is within 365 days from today- YELLOW

thanks in advance for your valuable time