we can see this example. for example today : 09-07-2010 and we want to calculate the age of each employee and fill it in cells D4 (for Bahasa Indonesia) and fill it in cell E4 (for english)
=DATEDIF(C4,$E$1,"Y")&" Tahun, " & DATEDIF(C4,$E$1,"YM") & " Bulan, " & DATEDIF(C4,$E$1,"MD") & " Hari"
formula for cells E4:
=DATEDIF(C4,$E$1,"Y")&" Years, " & DATEDIF(C4,$E$1,"YM") & " Months, " & DATEDIF(C4,$E$1,"MD") & " Days"
No comments:
Post a Comment