Forum Discussion
Amber Floyd
Jun 01, 2018Copper Contributor
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) = Expir...
Detlef_Lewin
Jun 01, 2018Silver Contributor
Amber,
you refer to D32 and E32. Is that correct? I would expect only one cell reference.