Date Validation

[Guest]

I have columns C and H in a spreasheet that have date validation format of
mm/dd/yr. My co-workers in China and Japan are not able to input and date in
these columns even in the right date format while the offices in Europe,
Singapore, Taiwan, Thailand.. are. Can anyone shade a light to theis problem?

 

[Rick Rothstein \(MVP - VB\)]

I have columns C and H in a spreasheet that have date validation

format of mm/dd/yr.

Can you provide more detail on what you have/did/mean by "date validation
format"?

Rick

 

[Guest]

Hi Rick
I am restricting the start and end dates that can be input in these columns
so I used date validation. I used excel's Data Validation tool as follows:

Setting:
Date

Allow:
between

Start Date:
10/01/2007

End Date:
10/31/2007

 

[Rick Rothstein \(MVP - VB\)]

I don't know if it will make a difference internationally, but try setting
up your start and end dates like this...

Start Date:
=DATE(2007,10,1)

End Date:
=DATE(2007,10,31)

instead of using text strings and see if that works.

Rick