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.
|