Expiry Date Alert Formula

[Muhammad_Zohaib]

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

[#2 · Accepted solution]

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.

[#3]

Thanks RTE

[#4]

@Muhammad_Zohaib 

What "alert" do you actually receive when applying this formula?