Date Reminder

Hi everyone

Im trying to get Excel to remind me on workbook open if a date is a 2 days past the recorded date.

for example in cell A12 i will have a datestamp of the 16 September 2012

and i want it to remind me if im 2 days overdue

Please Login or Register  to view this content.

This code always returns "not overdue" and i cannot get it to display the "overdue" message.

can anyone help to correct it please?

much appreciated

Try this...

If Range("A12").Value + 2 <= Date Then

change this line:

Please Login or Register  to view this content.

as

Please Login or Register  to view this content.

Thanks for the quick replies

first response worked like a charm thanks

Hi guys,

firstly thanks for the help but yesterday i was to quick to close the topic before actuall testing this code extensively.

I have been playing around with the characters plus and minues and "<" , ">" before the number and with the first reply and code supplied there will always have a Msg Pop up with reminder if its anywhere before the date or after it. the second reply and code unfortunately still gives me the "nothing response regardless of the date.

I need some help getting the exact dates i.e 7 days after the date.

Any suggestions?