Forum Discussion
Solved
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 ...
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.
What "alert" do you actually receive when applying this formula?