I'm using Excel 2007 and having an issue with data validation on a date field.

Goal:
To only allow a user to enter a date between the range of TODAY()-14 and TODAY() by using the Data Validation feature.

Problem:
When entering a valid date within the specified range, Excel displays validation error message stating the entered date is not valid.

Expected Result:
The validation error should only show when a user has entered a date that is before TODAY()-14 and after TODAY().

My Setup:
  1. Cell format: Short Date
  2. Data Validate Settings:
    • Allow: Date
    • Ignore Blanks: Checked
    • Data: Between
    • Start Date: =TODAY()-14
    • End Date: =TODAY()


Any help on figuring out why Excel displays the validation error message no matter what date is entered, would be greatly appreciated.

Thanks,

Micheal