- In short
- Creates a list of dates between a start date and an end date on a new sheet. You can include every day or only working days. Your current data is not changed. A new 'XLMind Dates' sheet. The source table is left as it is; Undo Last brings it back if needed.
What it is for
Create Date Range is used to generate a start..end date list (all/business days) on a new sheet.
When to use it
Most useful when you need to build a calendar dimension / date spine.
Example scenarios
- Build a calendar dimension / date spine.
What it needs
an options dialog (start/end/business-only/with-hierarchy); start>end refused; >5000 asks confirm. Supported data types: text, number, date (by selection).
How to use it
- Select the range holding the dates.
- On the XLMind Data tab, open the Create Date menu in the Date group and choose Create Date Range.
- Adjust the options in the window to fit your case.
- Confirm; a new 'XLMind Dates' sheet.
What it produces
A new 'XLMind Dates' sheet.
Effect on your data and undo
Create Date Range does not change your source data; the result is added as a separate item. Undo Last rolls the change back in a single step.
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
Confirmation for large operations. Size limits (>5000 asks confirm.).
Limitations
Size limits (>5000 asks confirm.).
Frequently asked questions
- Where will I see the result?
- A new 'XLMind Dates' sheet. Nothing is written on the sheet holding your source table.
- What happens to invalid or unexpected values?
- start>end refused.
- Does the result stay linked to the source?
- No, the output is static; rerun the tool after changing the source data for a current view.
- Any known limits?
- Size limits (>5000 asks confirm.).
Works well with
- Before you start, consider Create Date Hierarchy
- A good companion is Check Dates
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.