Friday, July 9, 2010

Calculate Age in Microsoft Excel 2003 and 2007

If we have employee data or students data that we want to know how old they are today ? and we want to use the age data of employee or students for something to analyse. so we can use DATEDIF function to calculate age in Microsoft Excel 2003 or 2007

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)

formula for cell D4 :
=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