FN-TEXT-001: Locale-tagged month, weekday and era names in TEXT follow their own table
Quirk · measured · recorded 2026-11-04
With a locale tag in the format, TEXT's names differ from common locale data. [$-407] (German) gives mmm for March as Mrz, while mmmm gives März. [$-411] (Japanese) gives mmm as a bare number, 1, while mmmm gives 1月. [$-419] (Russian) capitalises mmmm (Январь) but not mmm (янв), and capitalises ddd (Ср) but not dddd. The first year of the Reiwa era prints as 1, not 元年; g, gg and ggg give R, 令 and 令和, switching on 2019-05-01.
| Call and input route | Inputs | Excel | Correct value | Recorded in |
|---|---|---|---|---|
=TEXT(DATE(2023,3,15),"[$-407]mmm")formula-literal | As typed | Mrz | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=TEXT(DATE(2023,1,15),"[$-411]mmm")formula-literal | As typed | 1 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
=TEXT(DATE(2019,5,1),"[$-411]ggge")formula-literal | As typed | 令和1 | — | Excel 16.0.20527.20088 Current Channel, Windows 64-bit (NT 10.0.26200), x86-64, AMD Ryzen 7 4800H, en-ZA |
Basis: 170 recorded TEXT readings on one TEXT sheet.
Open: Era readings cover Heisei and Reiwa only. Earlier Japanese eras have not been read.
Evidence and capture sources
- DnaCalc · apps/dna-onecalc/tests/acceptance.rs f4930602d7b2f49cce13fb1bd030f7df2937adfa · locale_tagged_date_names_follow_the_retained_fn3_readings recorded readings pinned
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_text, row 6, column 4
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_text, row 78, column 4
- DnaCalc · crates/calc-func/tests/captures/fn3_questions/oracle.capture.json eceb809985e244e9d0a20f905e58fe57b8741ed8 · sheet fn3_text, row 164, column 4