Forum Discussion
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 English version of Excel.
More exactly, I need to format dates to that they are displayed in Japanese whatever language being used for Excel UI.
I personally use the English UI of Excel, but I need to format dates as (or instance for Wednesday January first, 2025 : 2025年01月01日（水）
If I choose yyyy"年"mm"月"dd"日（"aaa"）" then I get:
2025年01月01日（Wed）, which I don't want. I want the week day to be in Japanese!
Is there a specific code to do this, independently from the UI language?
I couldn't get any code that matches what I want, on the https://support.microsoft.com/ja-jp/office/%E8%A1%A8%E7%A4%BA%E5%BD%A2%E5%BC%8F%E3%81%AE%E6%9B%B8%E5%BC%8F%E8%A8%98%E5%8F%B7-5026bbd6-04bc-48cd-bf33-80f18b4eae68.
Many thanks in advance for any help
On Windows that is
or if convert to text
=TEXT(TODAY(), "[$-ja-JP]dddd mmmm dd")
5 Replies
Thanks to all of you.
I didn't put the [$-ja-JP] language code!
Now I know.Many thanks
SergeiBaklan is correct. To get the format you wanted:
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
