Forum Discussion
need help with a excel expiration date formula
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 days
Date 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?
Amber,
you refer to D32 and E32. Is that correct? I would expect only one cell reference.
