Something like:
This will obviously only check 1 row, I'm unsure about the structure of your worksheets without a template so I cannot help any more than that until you upload an anonymous template.![]()
Sub Happy If Range("C1").Value <> Range("B1").Value + 21 Then MsgBox "Please fill in date 2" End If End Sub
Bookmarks