Excel data validation

fateague Posts 1 Registration date Saturday April 1, 2017 Status Member Last seen April 1, 2017 - Apr 1, 2017 at 12:53 PM
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?