Calculate age in days/months/years in OpenOffice

Posted by Sanjay on Super User See other posts from Super User or by Sanjay
Published on 2012-05-30T18:38:56Z Indexed on 2012/05/31 10:44 UTC
Read the original article Hit count: 271

In need to find the age in days - months - years in OpenOffice.

There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates.

Age Calculation 
    You can calculate a persons age based on their birthday and todays date.
    The calculation uses the DATEDIF() function.        
    The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000. 
    (Makes you wonder what else Microsoft forgot to tell us!)   
    Birth date :    01-Jan-60       
    Years lived :   52   =DATEDIF(C8,TODAY(),"y")   
    and the months :    4    =DATEDIF(C8,TODAY(),"ym")
    and the days :  30   =DATEDIF(C8,TODAY(),"md")

One can calculate by below formula, but it is cumbersome to calculate months.

Another way to calculate age         
This method gives you an age which may potentially have decimal places representing the months.
If the age is 20.5, the .5 represents 6 months.             
Birth date :    01-Jan-60
Age is :    52.41    =(TODAY()-C23)/365.25

© Super User or respective owner

Related posts about openoffice.org

Related posts about worksheet-function