Date Validation in Excel - TechRepublic
Question
October 17, 2007 at 02:02 AM
vvelappan

Date Validation in Excel

by vvelappan . Updated 16 years, 9 months ago

I want to check whether the date entered is a valid date or not.
For ex., if i enter 11/122006 instead of 11/12/2006 [a “/” missing ] , should indicate that string as invalid date..Actually the entered date is considered as String not as Date.. Is there any Specific date function to check whether the entered date is valid or not.. It should not consider it as string.

This discussion is locked

All Comments