Date Reminder

[Brainstorm]

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

Private Sub Workbook_Open()
    Dim Msg As String
    Dim Msg1 As String
    If Range("A12") = TODAY + 2 Then
        Msg = " Overdue"
        MsgBox Msg
    Else
        Msg1 = "not overdue"
        MsgBox Msg1
      End If
End Sub

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

[nested.if1@gmail.com]

Try this...

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

[kvsrinivasamurthy]

change this line:

If Range("A12") = TODAY + 2 Then

as

If Range("A12") = Date + 2 Then

[Brainstorm]

Thanks for the quick replies

first response worked like a charm thanks

[Brainstorm]

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?