Hi Chip,
We've just checked the data. The dates in your excel are somehow not standard dates so that Excel could not recognize them and treat them as text. This is why the Date Formatting does not work.
Here is the solution:
Before you apply Date Formatting, please convert them to standard dates first. Please do as follows:
1. Select all the dates.
2. Find
Ranges & Cells group under the
Kutools tab.
3. Click
Content and select
Convert to Date.
After this, you will find
Apply Date Formatting working properly.
Amanda