Date Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I have columns C and H in a spreasheet that have date validation
format of mm/dd/yr.
Click to expand...

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

Rick
 
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
 
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
 
Back
Top