pop up reminder

[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

 

[Ecco]

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