Excel data validation

Closed

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?

Excel data validation
Transfer data from one excel worksheet to another automatically - Guide
Excel date format dd.mm.yyyy - Guide
Excel data validation list from table multiple columns - Guide
Digital data transmission - Guide
Multiple if statements in excel data validation - Excel Forum

Subscribe To Our Newsletter!