Forum Discussion
Custom Date format Excel 365 ddd/mm/yy
Hi all,
I am working on creating to-do list in Excel 365. I am wanting to display the due date in the following format (ddd - mm - yy) which I know how to do, you go into custom and write your own date format.
My date should read: Mon - 01 Jan - 25
I am using Office 365 excel online, when I go to custom it won't let me write the date format I want in, I can only pick from a pre-defined list.
My question is does anyone know how to change it, please, thanks Joel
1 Reply
Unfortunately, Excel for Web currently does not support creating or editing custom number/date formats (as far as I know).
You can only select from the pre-defined list of formats under “Number Format → Date.”This is a known limitation — even though the web app preserves existing custom formats created in the desktop app.
So if you try to type ddd - dd mmm - yy (or your desired Mon - 01 Jan - 25) directly in the web UI, it won’t accept it.
Workarounds:
Use a helper column with a TEXT formula
If you want to stay fully within Excel for Web, use a formula instead:
=TEXT(A2, "ddd - dd mmm - yy")
Then your output will look exactly the same, e.g.:
Mon - 01 Jan - 25
You can even hide the raw date column and just display this formatted version in your to-do list.
This is dynamic — if you change the date in A2, the formatted result updates automatically.
Use a helper column with a TEXT formula
If you want to stay fully within Excel for Web, use a formula instead:
=TEXT(A2, "ddd - dd mmm - yy")
Then your output will look exactly the same, e.g.:
Mon - 01 Jan - 25
You can even hide the raw date column and just display this formatted version in your to-do list.
This is dynamic — if you change the date in A2, the formatted result updates automatically.
This is a suggestion.
My answers are voluntary and without guarantee!
Hope this will help you.
