## [Solved] Can I calculate age based on birth date?

### [Solved] Can I calculate age based on birth date?

Hello,

I was wondering if this is possible. I have dates in the following formats mmddyyyy.

Thanks
Steve
Last edited by nzdreamer55 on Sat Jun 04, 2011 2:05 am, edited 1 time in total.
OpenOffice 3.3 on Windows 7 x64
nzdreamer55

Posts: 43
Joined: Fri Jun 03, 2011 6:49 am

### Re: Can I calculate age based on birth date?

However, 31121999 might be no date at all. It is 31,121,999 (31 million ...)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x

Villeroy
Volunteer

Posts: 25150
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Can I calculate age based on birth date?

Thanks Villeroy,

I'll take a look at this sheet and if I have questions post back. I'm going to mark it solved as it does what I need it to do. I just need to build around it once I understand the functions that are used. Again thanks for the help

Steve
OpenOffice 3.3 on Windows 7 x64
nzdreamer55

Posts: 43
Joined: Fri Jun 03, 2011 6:49 am

### Re: [SOLVED] Can I calculate age based on birth date?

If all you need is the amount of full years (the age) in OpenOffice.org only, =YEARS(start;end;0) will suffice.
My sheet demonstrates how to deal with time units and intervals in a compatible manner, using functions that are common in all spreadsheet applications such as Excel.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x

Villeroy
Volunteer

Posts: 25150
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: [SOLVED] Can I calculate age based on birth date?

That is great. I was only using years, but since you have a great demo sheet I might try to get a little more precise. Thanks again for the help. Will post back if I run into problems.
Steve
OpenOffice 3.3 on Windows 7 x64
nzdreamer55

Posts: 43
Joined: Fri Jun 03, 2011 6:49 am