| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
error alert for invalid date
hi
I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error alert for invalid date
Select the range..Say F1:F10
From DataValidation --From Validation CriteriaSelect 'Date' and mention the start date and end date.. --From Validation CriteriaSelect 'Custom' and mention the below formula.. =DAY(F1) -- Jacob (MVP - Excel) "nader" wrote: hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
error alert for invalid date
it worked. thankes
best regards nader "Jacob Skaria" wrote: Select the range..Say F1:F10 From DataValidation --From Validation CriteriaSelect 'Date' and mention the start date and end date.. --From Validation CriteriaSelect 'Custom' and mention the below formula.. =DAY(F1) -- Jacob (MVP - Excel) "nader" wrote: hi I want excel showes error alert if user enters invalid dates like "2010/2/29"... I can not creat it on data validation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Alert for Invalid Data doesn't work for data selected in col | Excel Worksheet Functions | |||
| Invalid Cell Reference error | Excel Worksheet Functions | |||
| Invalid qualifier error in macro | Excel Discussion (Misc queries) | |||
| invalid file format error | Excel Discussion (Misc queries) | |||
| error/ file format invalid | Excel Discussion (Misc queries) | |||
Hybrid Mode
