right now I have this code, I have tried variations of it but can't seem to get it to work. no mater what the date is in Rng1 the msgbox appears.

If Rng1.Value < DateAdd("m", -1, Date) Then
     If MsgBox("text if older than 30 days", vbYesNo) = vbNo Then
          ' does stuff if NO
     Elseif vbYes Then
          ' does stuff if YES
     End If
End If