Forum Discussion
Solved
How to format a date (week day) as Japanese, the the English version of Excel ?
Hi, I use the last Excel build of Mcrosoft 365 for Mac (presently Version 16.95 (25021621)), on the last version of macOS (presently 15.3.1) I need to format dates the Japanese way, but using the E...
On Windows that is
or if convert to text
=TEXT(TODAY(), "[$-ja-JP]dddd mmmm dd")
If you choose Date as the cell format and then select Japanese from the Locale drop-down:
you should be able to select the date format you need. After that, click the "Custom" category so you can see what the custom format string is.
Unfortunately, Excel will still display day names (abbreviated or not) in English