Date range checker
Separate in-period rows, outside rows and dates that need a convention or correction.
Inside period
3- Outside period
- 0
- Unresolved dates
- 0
Illustrative calculation · AUD where amounts are shown.
| Source row | Original date | ISO date | Result | Finding |
|---|---|---|---|---|
| 2 | 2026-09-21 | 2026-09-21 | Inside | |
| 3 | 2026-09-22 | 2026-09-22 | Inside | |
| 4 | 2026-09-23 | 2026-09-23 | Inside |
See how the number is made.
The tool compares calendar dates without a time-zone conversion. Ambiguous numeric dates stay unresolved until you select day/month/year or month/day/year. Invalid calendar dates are reported separately and never silently moved to another month.
The working
Inside the period means start date ≤ source date ≤ end date, including both boundaries.
A period of 21–27 September includes both 2026-09-21 and 2026-09-27. A row on 2026-09-28 is outside.
- Period: 2026-09-21 to 2026-09-27, including both dates.
- Date-only checks do not decide whether invoice date, payment date or service date is appropriate for your report.
Use the calculation basis and rules you have agreed. A tool result is a working record; it does not establish an entitlement or send a payment.