Just the date
Most random date tools hand you something like Saturday, March 14, 2026 whether you wanted the day name or not. This page starts with Show weekday switched off, so a result comes back as 2026-03-14 or March 14, 2026 and nothing more. The setting carries through everything the page produces: what you see on screen, what the copy button puts on your clipboard, the CSV file and the JSON.
Nothing else is excluded by default either — no weekend filter, no holiday calendar. Every day in your range has the same chance of coming up. If you do want the result restricted to working days, the options are still there; tick the weekend days or turn on public holidays and the same generator becomes the working-day version.
Formats without a weekday
Four output formats, none of which include the day name unless you ask for it:
YYYY-MM-DD—2026-03-14. ISO 8601, sorts correctly as plain text, and the only format that is unambiguous everywhere. This is what you want for spreadsheets, databases and code.MM/DD/YYYY—03/14/2026. US convention.DD/MM/YYYY—14/03/2026. Most of the rest of the world. Worth being deliberate about:03/04/2026means two different days depending on who reads it.- Long form —
March 14, 2026. For anything a person reads rather than a machine parses.
Why the weekday gets in the way
A day name looks harmless until the value has to travel somewhere. Paste Saturday, March 14, 2026 into a spreadsheet column and Excel stores it as text, not a date — the cell left-aligns, date filters stop working, and sorting puts "Friday" before "Monday" because it is sorting alphabetically. A parser expecting ISO 8601 rejects the string outright. A CSV import either fails the column type or silently keeps it as a string, which surfaces much later as a chart with no time axis.
Stripping the prefix by hand is fine for three rows and miserable for a hundred. Generating the list without it is the same amount of work and produces something you can paste straight in.
When the weekday is worth having
There is a reason it is a toggle rather than a permanent choice. If the list is going on a printed rota, into a calendar invite, or in front of someone who has to sanity-check it, the day name does real work — it is the fastest way to confirm at a glance that a "random working day" really did land on a Tuesday and not a Sunday. Tick Show weekday and it appears in every format, including the exported files. Untick it and it is gone again. The underlying dates never change; only how they are written out does.
Getting the dates somewhere else
Three ways out, all honouring the weekday setting. Copy puts the visible list on the clipboard as plain lines, one date each — paste into a spreadsheet column and every row lands in its own cell. CSV copies or downloads the same list as a file for import. JSON gives you an array of strings ready to drop into a fixture file or a seed script. For test data the combination that causes the least trouble is YYYY-MM-DD, weekday off, duplicates off — you get distinct, unambiguous, machine-readable dates.
The spreadsheet equivalent
In Excel and Google Sheets the day name is never part of the value; it is a display setting. =RANDBETWEEN(DATE(2026,1,1), DATE(2026,12,31)) produces a serial number, and whether you see "14/03/2026" or "Saturday, 14 March 2026" depends entirely on the cell's number format. If a weekday is showing and you do not want it, select the cells, press Ctrl+1 and pick a date format without ddd or dddd in it — you are not changing the data, only its mask.
The trap is the other direction: =TEXT(A1,"dddd, mmmm d, yyyy") converts the date into actual text, day name and all, and from that point it is no longer a date as far as every other formula is concerned. That is the spreadsheet version of exactly the problem described above.
Two more RANDBETWEEN caveats worth knowing: it is volatile, so the value changes on every recalculation until you freeze it with Paste Special → Values, and it happily returns the same date twice when filled down a column. Both are handled here — results hold still until you ask for new ones, and duplicates are off unless you allow them.
Getting the same dates back
Type anything into the Seed field — a ticket number, a campaign name, today's date — and the generator becomes deterministic: the same seed with the same range and settings returns the same list on any machine. Useful when the draw has to be auditable, or when you simply want to regenerate the fixture data you used last week. Leave it empty for a fresh draw each time. Share link encodes every setting, including the weekday toggle, into the URL.
Related
If you want the date without a year rather than without a weekday — "March 14" for a birthday or a yearly recurring event — use the month-and-day generator. For ISO 8601 specifically, there is a YYYY-MM-DD page. To keep every result on a Monday-to-Friday, use the random weekday generator.
Frequently asked questions
How do I get a random date without the day of the week?
That is the default on this page — Show weekday is already off, so results come back as the date alone. Press generate.
Does the weekday setting affect the copied text and the CSV?
Yes. The day name is either in all of the outputs or none of them: the on-screen list, the copy button, the CSV and the JSON all follow the same setting.
Can I put the day of the week back?
Tick Show weekday. The dates themselves do not change — only how they are written out.
Which format should I use for a spreadsheet?
YYYY-MM-DD with the weekday off. It is unambiguous, sorts correctly as text, and Excel and Google Sheets both recognise it as a date on paste.
Are weekends and holidays excluded here?
Not by default — every day in the range is eligible. Tick the weekend days or enable public holidays if you want working days only.