Review & quality / Field notes
Day-first dates in Australian Excel rosters
03/04 can mean 3 April or 4 March. Check the date axis, choose the intended order and inspect the preview before publishing.
An Australian team will often read 03/04/2026 as 3 April 2026. A system or exported file using month-first notation could read it as 4 March. Both are valid dates, so the spreadsheet cannot be trusted simply because a date looks reasonable. The question is whether the published shift lands on the right day.
Start with unambiguous dates
If you control the export, an ISO date such as 2026-04-03 is easier to distinguish from other formats. If the existing workbook uses day/month/year, retain it but include a date like 25/04/2026 in the same axis where possible: it gives a human a strong clue that 25 is the day. Do not manufacture dates from day initials such as M, T or W; a weekday heading is not a date by itself.
Check whether your roster runs across columns or down rows. In a horizontal sheet, dates may be in the header with workers underneath. In a columnar sheet, worker identifiers may be across the top while dates appear in a label column. A title line or decorative header can shift the real first date. The preview should show the actual date cells and their positions.
Use the review as a reading test
When the importer flags an ambiguous set, choose day-first or month-first according to the source workbook, not your computer locale. Examine several dates, including month boundaries, the first and last day and at least one known shift. An apparent match on one date may still hide an off-by-month error elsewhere.
| Source cell | Day-first reading | Month-first reading |
|---|---|---|
03/04/2026 |
3 April 2026 | 4 March 2026 |
12/11/2026 |
12 November 2026 | 11 December 2026 |
25/04/2026 |
25 April 2026 | Invalid month-first date |
These are illustrations, not an instruction to choose day-first for every file. A workbook exported from an overseas system may genuinely be month-first, even if its team is in Australia.
Check the window, not just the format
A workbook can contain previous and future months beyond the roster you mean to release. Choose the intended publication window in the import review. A correct date format with the wrong window could still omit next week’s crew or include an old rotation. Verify the reported first and last published dates and the count of entries before clicking Publish.
The selected window is limited to 140 inclusive days (20 weeks). An explicit override can select a historical period in any year when those dates exist in the source. That changes the included window; it does not repair an ambiguous date heading. Resolve the date-order action separately, refresh the preview and compare source boundaries. The first-100-entry sample may not include the final source date in a large roster.
Pay special attention to late-night shifts and travel statuses: a date in the roster is a work-plan label, not proof of a precise clock-in or a timezone conversion. If the source meaning is unclear, ask the person who owns the plan. RosterField does not invent start and finish times or calculate pay from a shift code.
A repeatable check for each upload
Open the source, note three known dates and the people rostered on them, then compare those points with the preview. Resolve any date-order prompt, update the preview and check the date range again. If the axes cannot be mapped confidently, improve the export or workbook structure first. Once published, earlier versions remain in history, but a historical record cannot undo confusion caused by releasing the wrong dates.
The upload checklist connects date checking with identifiers and statuses. The public demo lets you try the real import review with a fictional example or non-sensitive test file; it cannot calculate XLSX formulas or guarantee every site-specific date convention is correct.
Questions people ask
Should an Australian project always choose day-first?
No. Day-first is familiar locally, but an overseas export may use month-first. Compare dates that cannot be interpreted both ways against the source owner’s plan, then verify the first and last dates in the review.
What if only part of the workbook falls inside the selected window?
The selected window determines which roster dates you intend to publish. Check the boundary days and entry count; a correct date interpretation can still produce the wrong release if the window starts or ends on the wrong day.