Expiry Date Alert Formula

Hi Leila, could you please suggest how to put the formula for below SN NO. PRODUCT NAME PRODUCTION DATE EXPIRY DATE EXPIRY ALERT SNICKERS 21-Aug-21 19-Aug-22 ...

Formulas and Functions

Martin_Weiss
Feb 10, 2022
Hi Muhammad_Zohaib

sorry for not being Leila... 😉🙂🙂
You could use the following formula to get an alert in column E:
=IF(D2-NOW()<=15;"Expiry alert";"")

Or alternatively this one to get also the number of days left:
=IF(D2-NOW()<=15;"Expiry alert. "&ROUNDUP(D2-NOW();0)&" days left";"")
It might be, that you need to replace the ; with , depending on your regional settings.

If you really want an alert in Outlook, you would need VBA programming for that.