Thread: error alert for invalid date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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.
Reply With QuoteReply With Quote