- In short
- Looks at the dates in your selection and reports how many are real dates, how many are stored as plain numbers, how many are text, and how many look invalid or unclear. It only reports and does not change anything. A report Info dialog; nothing written. The source table is left as it is.
What it is for
Check Dates is used to analyze a date column's quality without changing it.
When to use it
It earns its place whenever you have to see date-data problems before fixing.
Example scenarios
- See date-data problems before fixing.
What it needs
A date column/range (no options dialog). Supported data types: text, number, date (by selection).
How to use it
- Select the range holding the dates.
- Run Check Dates from the Date group on the XLMind Data tab.
- Tune the choices in the dialog before confirming.
- Confirm; a report Info dialog; nothing written.
What it produces
A report Info dialog; nothing written.
Effect on your data and undo
Check Dates does not change your source data; the result is added as a separate item.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where is the output written?
- A report Info dialog; nothing written.
- What happens to invalid or unexpected values?
- Values never coerced.
- How are blank cells handled?
- Counted/reported.
- Does the result stay linked to the source?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- No special preconditions.
Works well with
- Before you start, consider Fix Dates
- Afterwards, try Create Date Hierarchy
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.