Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
We receive a sheet with about 1000 rows and need to do some validation on that sheet before it gets processed. One of the validations is for the column with the date. I need to validate that the date is in the "mm/dd/yyyy" format. I have looked and tried different but have not been able to do this. Could somebody tell me how to validate the date. Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
validating format | Excel Discussion (Misc queries) | |||
validating telephone format | Excel Worksheet Functions | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Validating a date field | Excel Discussion (Misc queries) |