help with a excel expiration date formula

[MsCrespo19]

Hi guys so I have a formula that needs to show 3 things as of today if Date is within a year ( of today) = Ok Date is within 30 days ( of today) = >30 daysDate has passed ( as of today) = Expired This is what I have and cant seem to get >30 days to show...=IF(D32="","",IF(TODAY()>DATE(YEAR(D32)+1,MONTH(D32),DAY(D32)),"Expired",IF(TODAY()>(DATE(YEAR(E32)+1,MONTH(E32),DAY(E32))-30),">30 days","OK")))Can you help? ​

 

[Tetra201]

Is this what you need?

=IF(D32="","",IF(TODAY()>D32,"Expired",IF(D32-TODAY()>30,"OK",">30 days")))

 

[MsCrespo19]

Thank you that is correct but I need It to calculate >30 days as well in addition to OK and Expired