I am using the change event to test if a date entered into cell G17 is more than 2 months ahead but don't know how to finish the code
This is what I have
Can someone tell me what to add to the Now() part?
This is what I have
VBA Code:
If Sheets("Refi").Range("G17").Value > Now() Then MsgBox "This date is more than 2 months ahead, please correct", vbCritical
Can someone tell me what to add to the Now() part?