I built a google doc template that works correctly, in which I report the formatted date in a column: TEXT ([DATA]; “MMMM”)
The month is written in English, how can I get the month written in Italian?
Solved! Go to Solution.
I think you may need to use a SWITCH() function based expression
Something like
SWITCH(TEXT([Data],“MMMMM”),
“January”, “gennaio”,
“February”, “febbraio”,
“March”, “marzo”,
“April”, “aprile”,
…,
-------,
“No Month”
)
Or simpler
SWITCH(MONTH([Data],
1, “gennaio”,
2, “febbraio”,
3 “marzo”,
4, “aprile”,
…,
-------,
“No Month”
)
I think you may need to use a SWITCH() function based expression
Something like
SWITCH(TEXT([Data],“MMMMM”),
“January”, “gennaio”,
“February”, “febbraio”,
“March”, “marzo”,
“April”, “aprile”,
…,
-------,
“No Month”
)
Or simpler
SWITCH(MONTH([Data],
1, “gennaio”,
2, “febbraio”,
3 “marzo”,
4, “aprile”,
…,
-------,
“No Month”
)
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |