How it works
Validate Gregorian dates, sort them chronologically, preserve duplicates, and report days since the previous sorted date.
Input definitions
- One YYYY-MM-DD date per line
- Plain text; maximum 200,000 characters.
A worked example
- One YYYY-MM-DD date per line
- 2026-01-10 2026-01-01 2026-01-03
Assumptions & limits
1–1,000 date-only values in years 0001–9999. Gaps are calendar days, not local elapsed hours.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
What happens to duplicate dates?
Duplicates are preserved. After sorting, consecutive duplicates show a zero-day gap. Use a duplicate-removal workflow first if each date should occur only once.
How does Sort dates and inspect calendar gaps work?
Validate Gregorian dates, sort them chronologically, preserve duplicates, and report days since the previous sorted date.
What are the limits of Sort dates and inspect calendar gaps?
1–1,000 date-only values in years 0001–9999. Gaps are calendar days, not local elapsed hours.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.