You have just pasted a month of timesheet dates into a sheet and something feels off — a day is missing, but which one? Reading every row by eye is slow, dull work, and Excel will not point at the gap for you; it just sits there, silent, while your totals quietly go wrong. This free missing dates finder will find missing dates in a list for you: paste your dates in, and it lists every date that should be there but is not, plus duplicates, out-of-order lines and lines it cannot read — then hands you a filled, complete list to paste back.
| Line | Input | Flag |
|---|---|---|
| Paste a date list above — results appear here. | ||
How to use the missing dates finder
Paste your dates into the box, one per line. They can come straight from a spreadsheet column — copy the column, paste it here, and you are done. Pick the format your dates are in: YYYY-MM-DD, DD/MM/YYYY or MM/DD/YYYY.
Then choose your step. Daily is the usual pick for timesheets and attendance logs. Weekly suits rosters and check-ins that happen once a week. Every N days covers anything in between, like a delivery round that runs every three days. If your list should only cover working days, tick “Skip weekends” and Saturdays and Sundays stop counting as missing.
Press “Find missing dates” and the tool walks your range from the earliest date to the latest, step by step, and checks each expected date against your list. Anything it expected but did not find goes into the missing list. Anything odd — a date you pasted twice, a line out of order, a line that is not a date at all — gets flagged in its own list. Below that, a filled complete list appears, ready to copy back into your sheet.
Nothing is uploaded. The whole check runs in your browser, so your attendance log or sales list never leaves your device.
Date formats, steps and skipping weekends
The format picker matters, because 03/04/2026 is the 3rd of April in one office and the 4th of March in another. Tell the tool which one your list uses and it reads every line that way. If your dates look like 2026-04-03, choose YYYY-MM-DD — that one is never ambiguous, and it is the safest format to paste back.
The step decides what “missing” means. Daily expects every calendar day in the range. Weekly expects one date every seven days from your first date, so a list of Monday check-ins with one Monday skipped shows exactly one gap. Every N days works the same way with your own number — useful for a fortnightly pay run or a four-day testing cycle.
Skip weekends is the toggle people reach for most. A Monday-to-Friday attendance log has no Saturday or Sunday rows, and without the toggle the tool would flag every weekend as missing. Tick the box and the walk skips Saturdays and Sundays, so only real working days can show up as gaps.
You can also pin the range yourself. Leave the start and end boxes empty and the tool uses your earliest and latest dates. Fill them in to check a fixed window instead — handy when your list starts mid-month but you want to check the whole month.
Worked example: gaps in an attendance list, filled
Say you paste in this short attendance list, in YYYY-MM-DD format, with the step set to daily:
2026-11-02
2026-11-03
2026-11-05
2026-11-09
2026-11-05
not a date
The tool reports 4 present dates and 4 missing dates: 2026-11-04, 2026-11-06, 2026-11-07 and 2026-11-08. Tick “Skip weekends” and the two weekend days drop out, leaving 2026-11-04 and 2026-11-06. It also flags that 2026-11-05 appears twice — the second one sits on line 5, after 2026-11-09, so it is out of order too — and that “not a date” on line 6 is not a date at all. The filled list runs from 2026-11-02 to 2026-11-09, one date per line, ready to paste back into your sheet.
That is the whole point: instead of reading the list and guessing, you get the gaps named, one by one, and a clean list with them filled in.
Add the missing dates back to your list
The finder returns the missing dates in order, so you can paste the filled list straight back where it came from. Duplicates, out-of-order lines and invalid lines are flagged instead of breaking the result.
Related date tools
Before you check for gaps, your dates need to be readable. If a pasted column comes out in a jumble of formats, the Messy Date Cleaner sorts the formats out first, so this finder can read every line.
And once your list is complete, you can measure it: the Bulk Days-Until / Days-Since List tells you how many days are left until — or have passed since — every date in the list, all at once.
Frequently asked questions
What counts as a missing date?
A missing date is any date the tool expects in your range but cannot find in your list. The range runs from your earliest date to your latest, and the step decides which dates are expected — every day for daily, every seventh day for weekly, or every N days for a custom step. A date is only missing if it matches that pattern, so a Tuesday is never missing from a weekly Monday list.
How does the weekly step work?
Weekly starts at your first date and expects one date every seven days from it. If your list starts on a Monday, it expects Mondays. A skipped Monday shows up as one missing date, and the filled list adds it back in the right place. If your list actually starts on a Wednesday, the whole pattern anchors to Wednesdays instead.
What happens to duplicates, out-of-order lines and invalid lines?
They are flagged, not quietly dropped. A date that appears twice is listed once in the duplicates list with its count. A line that comes before an earlier date is flagged as out of order. A line the tool cannot read as a date — a typo, a word, a half-cut paste — is flagged as invalid, with its line number, so you can fix it at the source. None of them stops the rest of the check from running.
Is anything uploaded?
No. The tool runs entirely in your browser — your dates are processed on your own device and never uploaded, stored, or sent anywhere.
Can I add missing dates in Excel with this tool?
Yes, in the paste-list sense. Paste your dates from Excel, the finder spots the gaps and returns the list with the missing dates filled in, and you copy the filled list back into your sheet. No formula is needed, and the weekly step and skipping weekends options work the same way.
Privacy note: this tool runs entirely in your browser. Your dates never leave your device — nothing is uploaded, stored, or tracked.
Related tools: you can find missing numbers in a sequence the same way, and if you run a guesthouse or venue, check whether two bookings overlap.