Beginner- How to set an automatic email notification 3 months before an expiry date?

Hi there,

So I am a beginner to Excel, I have found some threads on this question from other people using older versions of Excel. I am running an Excel 2013 Version. If anyone knows how to set an automated email on a date (to use for several) in a sheet I would appreciate your help.

I have a list of license expiry dates and they need to be bought to my business's attention about 3 months before they actually expire. This will help in controlling renewal payments without having to remember about 20+ vehicles individually and constantly.

How do I go about this, if you know the codes and instructions on formatting the codes it would be much appreciated.

Please help

Hi,

Welcome to the Forum, please upload a sample template of your workbook here using "Go Advanced" option.