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:
Post a Comment