Prev: Index using a defined name array
Next: Calendar
From: nader on 27 Apr 2010 05:11
hi
I want excel showes error alert if user enters invalid dates like
"2010/2/29"...
I can not creat it on data validation.
From: Jacob Skaria on 27 Apr 2010 05:20
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)


--
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.
From: nader on 27 Apr 2010 06:51
it worked. thankes
best regards
nader

"Jacob Skaria" wrote:

> 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)
>
>
> --
> 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.
 | 
Pages: 1
Prev: Index using a defined name array
Next: Calendar