muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to insert text "Tahun" into date like this
i have use but not working
i want the result
BULAN JANUARI TAHUN 2022
if possible please, don't use vba
anyhelp, thank in advance
.susanto
how to insert text "Tahun" into date like this
i have use but not working
Excel Formula:
=CONCATENATE("BULAN ";UPPER(TEXT(TODAY();"Tahun";"mmmm yyyy")))
BULAN JANUARI TAHUN 2022
if possible please, don't use vba
anyhelp, thank in advance
.susanto