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

nzdreamer55 · Post by **nzdreamer55** » Fri Jun 03, 2011 6:51 am

Hello,

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

Thanks
Steve

edit this topic's initial post · Post by **Villeroy** » Fri Jun 03, 2011 7:54 am

All you want to do with dates and times: http://user.services.openoffice.org/en/ ... hp?id=7015
However, 31121999 might be no date at all. It is 31,121,999 (31 million ...)

nzdreamer55 · Post by **nzdreamer55** » Sat Jun 04, 2011 2:04 am

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

edit this topic's initial post · Post by **Villeroy** » Sat Jun 04, 2011 2:15 am

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.

nzdreamer55 · Post by **nzdreamer55** » Sat Jun 04, 2011 2:42 am

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

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

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

Re: Can I calculate age based on birth date?

Re: Can I calculate age based on birth date?

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

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