error alert for invalid date

  • Thread starter Thread starter nader
  • Start date Start date
N

nader

hi
I want excel showes error alert if user enters invalid dates like
"2010/2/29"...
I can not creat it on data validation.
 
Select the range..Say F1:F10

From Data>Validation>
--From Validation Criteria>Select 'Date' and mention the start date and end
date..

--From Validation Criteria>Select 'Custom' and mention the below formula..
=DAY(F1)
 
it worked. thankes
best regards
nader

Jacob Skaria said:
Select the range..Say F1:F10

From Data>Validation>
--From Validation Criteria>Select 'Date' and mention the start date and end
date..

--From Validation Criteria>Select 'Custom' and mention the below formula..
=DAY(F1)
Click to expand...
 
Back
Top