Wednesday, October 29, 2008

Finding Age (Year, Month, Day) with Microsoft Excel



To find the age quickly with Microsoft Excel
DATEDIF can use the function (), for example:

the date format in English:

A5=05/20/1970
B5=DATEDIF(A5,TODAY(),"y")&" years "&DATEDIF(A5,TODAY(),"ym")&" months "&DATEDIF(A5,TODAY(),"md")&" days"

Result: (if today=10/30/2008)
38 years 5 months 10 days

No comments: