pop up reminder

  • Thread starter Thread starter SteveH
  • Start date Start date
S

SteveH

First off,I have a general knowledge of excel.
I have a spreadsheet that I use to simply record actions through the
lifetime of a project that I'm working on.
What I'd like to do is, when I input a date for an action that excel reminds
me in two weeks time to check on that action (either through excel - if
possible or through the calender of outlook).
Does anyone know if this is possible and how I'd go about it?
thanks in advance,
SteveH
 
One simple way to solve this problem is to use IF-
function. If you enter the date in cell A5 you could place
a formula =IF(TODAY()-A5>14;"CHECK";"") in B5. In this
case text CHECK appears, if the date is more than two
weeks old.

If you want Excel to interact with Outlook, you need to
use VBA.

Ecco
 
Back
Top