I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format:
From the research I've done, I've come across what I thought would be a solution here:
But unfortunately I'm unable to get this to work.
Entering the date
01-01-13 which should, if I've understood it correctly pass the validation, actually fails and I receive the validation error message.
I just wondered whether someone may be able to look at this please and offer some guidance on where I may have gone wrong.