Excel 2013 Notifications?

olds

Elite Member
Mar 3, 2000
50,129
781
126
I want to set "15 day" and "Due"automatic reminders from an Excel sheet. Preferably by email.

IE:
I have an assignment that is tracked by a number and all assignments must be completed within 30 days of the Evaluation Date.

So I enter the assigned "Evaluation Date" in a cell: 4//2016.

I'd like to get automatic notifications after 15 days and then again on the due date.

I'd also like to be able to turn off the notifications by entering a date in a cell called "Completion Date".

Is this possible?
 

Tweak155

Lifer
Sep 23, 2003
11,449
264
126
There are a number of ways to do this. Email is easiest if you have Outlook configured, otherwise it could be a little bit of work to use another email system.

Do you open this file daily? If so it may just be easier to have a pop up summary or something of that nature when you open it. If not, you can set windows tasks to execute macros in the workbook on set schedules.
 

olds

Elite Member
Mar 3, 2000
50,129
781
126
Thanks. it wouldn't be open daily, it would have to run in the background. Or I could just never close it if needed.