Ask Your Question

does calc have a datediff function? [closed]

asked 2012-03-11 22:43:18 +0200

oldrooky gravatar image

Given a person's birth and death dates, would like to say person was 83 years 2 months and 13 days old.

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 2015-10-15 15:39:31.390811

2 Answers

Sort by » oldest newest most voted

answered 2012-03-13 13:09:22 +0200

Timon gravatar image

2 variants (if you want to know not only quantity of years)

DAYS Calculates the difference in days between two dates.

DAYS360 Calculates the difference in days between two dates based on a 360-day year (but all we know that 365 or 365 days in year, not 360)

All other functions are in DATE/TIME category in functions list.

edit flag offensive delete link more

answered 2012-03-12 03:29:37 +0200

m.a.riosv gravatar image

In LibreOffice help:


Calculates the difference in years between two dates.


YEARS(StartDate; EndDate; Type)

StartDate is the first date EndDate is the second date Type calculates the type of difference. Possible values are 0 (interval) and 1 (in calendar years).

edit flag offensive delete link more

Question Tools


Asked: 2012-03-11 22:43:18 +0200

Seen: 4,716 times

Last updated: Mar 13 '12