date validation

[jan collins]

excel 2002

How do you set date validation so that month is not larger
then 12, day not larger then 31 ---

also i need to know you stop entry of date later then
today ---

thanks

jan

 

[Norman Harker]

Hi Jan!

Probably all you need is:

Data > Validation
Allow dropdown select Date
Start Date Type:
01/01/1900
End Date Type:
=Today()
"Follow your nose" with Input message and Error Alert
OK

Then the user can't put in a date after today. It also bars impossible
dates like 31-Jun-2003.

But there are other methods and generally I'd prefer a 3 cell entry
method with an error alert on the result.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Saturday: Bosnia-Herzegovina (Petrovdan); Canada,
Northern Ireland, and Eire (Orangemen's Day); Kiribati (Independence
Day); Malaysia (Birthday of the Yang di-Pertua Negi Pulau Pinang);
Micronesia (Micronesian Day); Sao Tome & Principe (Independence Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.