Ask Your Question

how to calculate age from birth day in libreoffice calc? [closed]

asked 2015-03-18 20:24:12 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to calculate age like Years, Months and Days between Date_Of_Birth and Todays Date. Its work fine in EXCEL =DATEDIF() function, But Libreoffice Calc i could not calculate. Please can anybody help me in these regard...

I use UBUNTU 12.04 LTS LibreOffice 3.5

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-06 22:35:58.729195

1 Answer

Sort by » oldest newest most voted

answered 2015-03-18 22:34:10 +0100

Rugslug gravatar image

updated 2015-03-22 17:51:30 +0100

See bottom of Answer for completed Spreadsheet file.


where interval is in quotes and is specific letters. I tested this in Windows Portable Apps v 3.6.5

Update: DATEDIF was added with 3.6

image description

Update 2: my first recommendation is to update to v 3.6 or newer. It is a very streamlined and versatile function.

I've attempted some work arounds but it's not so easy for me. I think there are experts out there that may be able to develop a better set of formulae for this purpose.

I've used the YEAR and MONTHS Functions, but this is the easy part. (They both function in Win7 PortApps 3.5)

=YEAR(Start Date,End Date,Type)

Type =0 Time Interval or =1 for calendar years (I used 0 for calculating years since birthdate)

=MONTHS(Start Date,End Date,Type)-YEAR(Start Date,End Date,Type)*12

Type can =0 or =1 and the YEAR portion of the formula can reference the cell for the YEAR calculation above

Unfortunately, calculating the numbers of days from the last birthday is a little more challenging (HELP!) but we're 2/3 of the way there. The story will continue....


I think I've got it. I've attached the file as the formula is a little convoluted. Hopefully it works for all date possibilities.

Year Counter.ods

edit flag offensive delete link more


Thanks for your Valuable cooporation...

Golam007 gravatar imageGolam007 ( 2015-03-22 12:21:17 +0100 )edit

Question Tools

1 follower


Asked: 2015-03-18 20:24:12 +0100

Seen: 8,613 times

Last updated: Mar 22 '15