Thread: date validation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LM LM is offline
external usenet poster
 
Posts: 21
Default date validation

Hi Peo
I have set up the following date valdiation using the Excel DATA Validation

Allow:
Date

Data:
between

Start date:
10/01/2007
End Date:
10/31/2007







"Peo Sjoblom" wrote:

What's your exact formula?


--


Regards,


Peo Sjoblom



"LM" wrote in message
...
I have colums C and H that have the date valdiation formula of mm/dd/yy. My
co-workeres in China and Japan can not input any data in these two colums
as
they are getting date vaidation error. Every other coutnry I work wiht are
able to input the date. What di I need to do in order for China and Japan
to
be able to enter the dates in these two columns?