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


"LM" wrote in message
...

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)" wrote:

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