Datediff with non-english on the referent cell.

[Boun]

I need to replace year, month and day with non-english on referent cell such as Pee for years(F2), deun for month(G2) and Vaan for days(H2).

Sub Macro3()
'
' Macro3 Macro
R = 2

Cells(R, 4) = "=DATEDIF(RC[-2],TODAY(),""y"")&"" year(s) "" &DATEDIF(RC[-2],TODAY(),""ym"")&"" month(s) "" &DATEDIF(RC[-2],TODAY(),""md"")&"" day(s)"""

Range("D3").Select

End Sub

Result: 3 Pee 2 deun 1 Vaan

[martindwilson]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here