Hello,
I was wondering if this is possible. I have dates in the following formats mmddyyyy.
Thanks
Steve
[Solved] Can I calculate age based on birth date?
-
- Posts: 43
- Joined: Fri Jun 03, 2011 6:49 am
[Solved] Can I calculate age based on birth date?
Last edited by nzdreamer55 on Sat Jun 04, 2011 2:05 am, edited 1 time in total.
OpenOffice 3.3 on Windows 7 x64
Re: Can I calculate age based on birth date?
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 ...)
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 43
- Joined: Fri Jun 03, 2011 6:49 am
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
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
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.
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 43
- Joined: Fri Jun 03, 2011 6:49 am
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
Steve
OpenOffice 3.3 on Windows 7 x64