Software

Ask something
Question Locked

Date Validation in Excel

0 helpful
4 replies

by vvelappan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

4 replies

by scott_heath

You could use VBA to validate the dates. the IsDate() Function might help, but I don't know if it will correct a single missing date seperator. You could write your own logic that break apart them string. or use a mask on the cell that enters data in a ##/##/#### format.

by ukvetri

Hi,

Just do it for find a date whether valid or not. it is a temporary solution. i'l let you know when i find best than this.

paste your dates in another sheet or another empty location in same sheet. select all the dates you pasted. Go format-cells-category. then change category type "date" to "general". Now valid dates wouldnt have / symbol. So you can find / easily by find & replace.

Udhaya

This discussion is closed to new replies.