Age Calculation

[Muntasar]

Hi,
Is it possible to calculate age in an excel sheet? How?

My friends birthday is 17-09-1970, today is 25-08-2003.
Today how old is he?

Thanks

 

[Lydya]

A1= 17/09/1970
B1= 25/08/2003
C1=DATEDIF(A1,B1,"y")
The third argument of the function is the time unit you want to calculate (y
= years, m=months, d=days ...)

 

[Bryan]

Try
a1=17/09/1970
B1 =DATEDIF(A1,NOW( ),"y") & " years, " & DATEDIF(A1,NOW( ),"ym") & "
months, "& DATEDIF(A1,NOW( ),"md") & " days"

Bryan