Expiry Date Notification

[garnetmorse]

I have 2 cells: one with a date of activation (ie: January 5, 2011) and the other with the date of expiration (ie: January 4, 2012). I would like to set it up so when it is 30 days from the term expiry, a notice would come up stating "30 days until expiry".
I would sure appreciate some help on this.
Thanks

 

[RSXchin]

What kind of notification? Do you want it to send an email? or just have it in a different cell?

 

[garnetmorse]

It would be great if it appeared in another cell

 

[garnetmorse]

I could still use some assistance if possible...

 

[kpark91]

Suppose your date of expiry is in B1

Put this in C1
=IF(B1-NOW() <= 30, "30 days until expiry", "")

 

[R Pelle]

Also consider applying conditional formatting on the enddates.

Green: Cell value Greater than = today()+30
Amber: Cell value between =today()+1 and =today()+30
Red: Cell value Less than or equal to = today()+30

 

[garnetmorse]

How would I enter the colour values in a cell? Thanks for the help people.

 

[R Pelle]

Try http://www.metacafe.com/videos/how_to/
and search on Conditional formatting

 

[garnetmorse]

It's all good. Thank you all for your help. Cheers