Days Between Dates
Absolute elapsed days between two valid dates.
Absolute elapsed days between two valid dates.
What this tool does
Absolute elapsed days between two valid dates.
Review the output before the next step
The function operates on the supplied source and listed assumptions. Confirm the output format fits the receiving workflow before copying it into a production record. The fields available on this page are Start date, End date. Absolute elapsed days between two valid dates.
How it works
Absolute elapsed days between two valid dates.
Inputs
| Field | Example | Definition |
|---|---|---|
| Start date | 2026-01-01 | Enter the calendar date in YYYY-MM-DD format. This field represents start date, not a count of working days. |
| End date | 2026-12-31 | Enter the calendar date in YYYY-MM-DD format. This field represents end date, not a count of working days. |
Step-by-step guide
Prepare the source
Supply Start date, End date. Keep the original material so the output can be compared with it.
Use Days Between Dates
Check Start date, End date, then select Use Days Between Dates.
Use the result
Compare the days between dates result with the unchanged source before copying or downloading it.
When to use it
Absolute elapsed days between two valid dates. The function operates on the supplied source and listed assumptions. Confirm the output format fits the receiving workflow before copying it into a production record.
Example and scope
Example inputs: Start date: 2026-01-01; End date: 2026-12-31.
The function operates on the supplied source and listed assumptions. Confirm the output format fits the receiving workflow before copying it into a production record.
Worked output
364 days
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026