Forum Discussion
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 | 15 DAYS BEFORE, IF POSSIBLE TO GET ALLERT THROUGH THE CALENDER |
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.
3 Replies
What "alert" do you actually receive when applying this formula?
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.
- Thanks RTE
