Notify Me with Excel 1

[pandabear1]

I have a spreadsheeet where I need certain cells to remind me a change is due. An example is three years from this date this part is due to be changed.
Can Excel due this and how?
Thanks

 

[SkipVought]

Hi,

If the DueDate is in A1, and the NotifyDays is in A2, then
[tt]
B1: =IF(A1-A2<TODAY(),"NOTIFY","")
[/tt]

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

what needs to be changed in three years? Is it a formula?

You might be able to design things now so that you don't need to change anything in three years.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[pandabear1]

I have a date say:
March 10, 2009 and I would like some indicator in three years. Something like cell turns red or datat in cell turns red.

 

[SkipVought]

Use Format > Conditional Formatting
[tt]
Formula Is: =A1<Today()+365*3
[/tt]
and select an appropriate format.


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[pandabear1]

I added that formula to the cell that I have the date in and I used a format that the date turns red. I put todays date in and it turned red, what did I do wrong. I put the exact formula you indicated above in the conditional format.

 

[randy700]

How about...
=A1 > Today()+365*3

Randy

 

[SkipVought]

Play around with it, man!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

pandabear1: Today() is a dynamic formula - it always displays the current date. Right now it returns March 10, tomorrow it will return March 11.

My point is that you need to add 3 years to the other side of the equation:
[tab][COLOR=blue white]= edate(A1, 36) < today()[/color]

(or [COLOR=blue white]=a1 + 365 * 3 < today()[/color] )

Put in a date 3 years ago the the formatting will be applied.


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[pandabear1]

that didn't work Randy. By the way I have been playing around with it.

 

[AnotherHiggins]

Since it looks like we were both posting at the same time, I just wanted to make sure you saw my last post, pandabear1.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[pandabear1]

thanks John that did it.