Hi..
I'm trying to validate that a person has a datetime in the format CCYYMMDDHHMMSS and that it is a valid date and less than today. Been messing around with IF, MID, MEDIAN etc without much success. Can it be done? even for the first 6 characters as I know there is a formula size limit - been trying to avoid macros, but if thats my only option...
I look forward to your expert opinion...
Bookmarks