Weekday Date Filter

You export the rota on a Friday afternoon, paste the dates into your sheet, and there they are again: Saturdays and Sundays sitting in the middle of a work schedule that was never meant to include them. You could delete them one by one, or build a FILTER formula with WEEKDAY and hope you get the logic right — but when you just need a weekday date filter, cleanly and in one pass, this free tool does the dull bit for you: paste the list, pick weekdays, and copy back only the dates that belong in a working week.

Weekday and Weekend Date List Filter

Paste your dates, one per line, pick what to keep, then press Filter Dates.

How to use the weekday date filter

Paste your dates into the box, one per line. The tool reads the usual formats — 2026-11-02, 02/11/2026, and 2 November 2026 all work — so you don’t have to tidy the list first.

Choose what to keep: weekdays only, weekends only, or chosen days. Then pick the date format you want back. Press Filter Dates and the tool works out the weekday of every date, keeps the ones that match, and leaves the rest out.

You’ll see how many dates were kept and removed, and any line it couldn’t read is flagged on its own, so nothing slips past you unnoticed. The filtered list stays in its original order, ready to paste straight back into your sheet or rota.

Weekdays-only vs weekends-only vs chosen days

Weekdays only keeps Monday to Friday and drops Saturdays and Sundays. That’s the one most people reach for when a rota export or a booking list has weekend dates mixed in with working days.

Weekends only does the opposite: it keeps Saturdays and Sundays and drops the rest. If you run a weekend rota, a market stall, or a Saturday class, this gives you that list in seconds.

Chosen days is for the in-between cases. Tick the days you want — Mondays and Fridays, say — and only those dates survive. It’s handy for part-time rotas, weekly deliveries, or a class that runs on two set days a week.

Whichever mode you pick, the tool checks each date on its own. A date is never kept just because the one above it was — each line stands or falls on its own weekday.

Worked example: a 14-date export filtered to its 10 weekdays

Say your export covers two full weeks, 2 November to 15 November 2026. That’s 14 dates: ten weekdays and four weekend days tucked in among them.

Paste in 2026-11-02 through 2026-11-15, choose weekdays only, and press Filter Dates. The tool keeps 2026-11-02 to 2026-11-06 and 2026-11-09 to 2026-11-13 — ten dates — and removes the two Saturdays (7 and 14 November) and the two Sundays (8 and 15 November).

The notice reads “Kept 10 dates, removed 4 dates.” and the table below the result shows the same counts, so you can check the maths at a glance before you paste the list back.

Keeping order for pasting back

The filtered list comes back in the same order you pasted it in. Nothing is sorted, shuffled, or grouped by weekday, because a rota that comes back in a different order is a rota you have to fix by hand.

That matters most when your dates sit next to names, shifts, or rooms in another column. Filter the dates here, copy them, and paste them back over the same column — each date still lines up with the row it came from.

If you change the output format, the order stays the same too. The dates just look different: 02/11/2026 instead of 2026-11-02, for example. Pick the format your sheet already uses and the paste will slot straight in.

Related date tools

If your list needs more work before you filter it, start with the Messy Date Cleaner to fix dates pasted from Sheets, then check for gaps with the Missing Dates in a List Finder. And if every date needs to move by the same number of days, the Bulk Date List Shifter does that in one pass.

Frequently asked questions

Are bank holidays removed too?

No — the tool only looks at the day of the week, so a bank holiday that falls on a Monday stays in a weekdays-only list. If you need those out too, filter the list here first, then delete the holiday dates from the shorter list; it’s a much smaller job once the weekends are gone.

What if a date is invalid?

Any line the tool can’t read — a typo like 2026-13-40, a stray word, or a half-pasted row — is flagged in its own list below the results and left out of the filtered list. Fix the line and run the filter again, and the counts will show the line as kept instead of invalid.

Does the original order change?

No. The kept dates come back in exactly the order you pasted them in, with nothing sorted or grouped. That’s deliberate: if your dates line up with names or shifts in another column, the filtered list still lines up with the same rows when you paste it back.

Can I keep only Mondays and Fridays?

Yes — choose “Chosen days only”, tick Monday and Friday, and press Filter Dates. Only Mondays and Fridays stay in the list, and the notice tells you how many dates that left you with, so you can check it against the rota at a glance.

How do I filter dates by weekday in Excel without a formula?

Paste the date list here, choose weekdays, weekends or chosen days, and the filter returns only the matching dates in their original order, ready to paste back into Excel. Bank holidays are not removed, so check those separately.

Can I keep only the weekend dates from a list?

Yes. Choose weekends-only and the filter drops the weekdays, leaving Saturdays and Sundays in their original order. Choose chosen days instead if you want only Mondays and Fridays, or any other set of days.

Nothing is uploaded or stored: the filter runs in your browser, so your dates never leave your computer. Paste a list, pick the days you want, and get a clean list back in seconds.

Leave a Comment