Date and reminder in excel

[getdeeptir]

Hi all


Glad to have found this forum. I need to design an excel sheet where "Invoice date, due date and a reminder" has to be input.


When i input the invoice date, the due date should come after 30 days from the invoice date. This i was able to achieve with a simple formula: =sum(invoice date+30).


But the problem is "reminder". I need to get a reminder prior to 5 days of the due date. Hope you understood. For eg., if the due date is 20th october, on 15th october, the reminder column should display a message like "5 days left".


and when it is only 3 days left till the due date, "the column should display the message "only 3 days left".


On the due date a red warning like the stop signal excel has.

Is this possible in excel ?


Thank you.

Deepti

 

[xld]

Use conditional formatting. See http://www.xldynamic.com/source/xld.CF.html#due

 

[getdeeptir]

Thank you for that suggestion and help. But, can you tell me if messages like that can be displayed using "if" formulas and if yes, how ?

 

[Mike86]

Something like this will work:


=IF(F11>(E11-5),TEXT(F11-NOW(),"#")&" days left")


The color changes can be done with conditional formatting as xld mentioned.

 

[getdeeptir]

Tnq very much. i will try this and get back to you. tnx again.