Date Validation Not Working

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