Formula Insert text into date format

[muhammad susanto]

hi all..

how to insert text "Tahun" into date like this
i have use but not working

=CONCATENATE("BULAN ";UPPER(TEXT(TODAY();"Tahun";"mmmm yyyy")))

i want the result
BULAN JANUARI TAHUN 2022
if possible please, don't use vba
anyhelp, thank in advance

.susanto

 

[Peter_SSs]

Try this (but with semi-colons instead of commas)

22 01 24.xlsm
	A
1	BULAN JANUARY TAHUN 2022
Text in date

Cell Formulas
Range	Formula
A1	A1	=CONCATENATE("BULAN ",UPPER(TEXT(TODAY(),"mmmm ta\hu\n yyyy")))

 

[muhammad susanto]

hi Peter , you're brilliant!!! Thank you.

 

[Peter_SSs]

You're welcome. Cheers.

Rather than work out which letters require the preceding \, it may be simpler to put one in front of any letter that you want treated as its actual value like this

=CONCATENATE("BULAN ",UPPER(TEXT(TODAY(),"mmmm \t\a\h\u\n yyyy")))