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: 273
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