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