Excel - how to set up date reminders

Hello Mulin,

Hope you enjoyed your Microsoft Excel Advanced
course with Best STL.

Thank you for your question regarding how to set up date reminders.

The first part is easy. Dates are actually numbers, so to create a formula to view a date 9 months earlier simply subtract the number of days from the cell containing the date. Assuming you have a date in cell C2 (23/02/2014) and you are going to create a formula in cell D2 which calculates a date 9 months before the date in C2 as follows:

=C2-270 Result will be 29/05/2013. You may have to format the result with a date format. If you add conditional formatting to the result column you can highlight the cell if the date is less than say tomorrow's date.

To produce reminders via email will require the use of VBA code and you are welcome to participate in our Excel VBA courses.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer