ExcelBanter - error alert for invalid date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - error alert for invalid date (https://www.excelbanter.com/excel-worksheet-functions/262512-error-alert-invalid-date.html)

Nader

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.

Jacob Skaria

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.

Nader

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.

All times are GMT +1. The time now is 02:51 AM.