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