Excel data validation [Closed]

Report
Posts
1
Registration date
Saturday April 1, 2017
Status
Member
Last seen
April 1, 2017
-
I manage a ongoing membership list in Excel. I've noticed typing errors in the the date field for the entered date. Is there a way I can alert the data entry person that she has entered a invalid date? I found 3 of them that are in the future so I was thinking perhaps I could test against the current date?