Automatic Reminders Based on Dates

[jayjay1990]

Hi,


My name is james and i have created a spread sheet with various dates and as my case load grows i will be adding different dates, the dates dont bother me but I need to know how or if someone can assist me in doing a automatic reminder 21 days prior to any date i put, and possibly im looking for a pop up and a color change. my office uses outlook and it would be amazing if i could get an email as well. i have attached the spread sheet and an example

[hoyasaxa215]

Wouldn't it just be easier to enter this info directly into your Outlook calendar and schedule reminders from there?