Calculating age in Calc – LibreOffice 6-4

From The Document Foundation Wiki
Jump to: navigation, search

Template:TopMenu/en Template:Menu/en

Other languages:
dansk • ‎Deutsch • ‎English


The formula
View of the table from 07.06.2020.

The video "Calculating age in Calc - LibreOffice Calc 6.4" links to this page here, which provides further information.

This video shows how, with the help of formulas in Calc, the age can be calculated based on the date of birth.

Link to the Video

Link to the Video: Calculating age in Calc – LibreOffice 6-4

The Formula

See picture on the right "The formula".

The functions


DATEDIF(Start date; End date; Interval)

Returns the number of whole days, months or years between "Start date" and "End date".

Interval is a sign.

Value for Interval are the expressions "d", "m", "y", "ym", "md", or "yd".


IF(Test; Then value; Otherwise value)
Results in a Truth check , which is to be carried out.


Returns the current computer system date .

The Table

See picture on the right "View of the table from 07.06.2020".

Further Informations

Age calculation - Wikipedia +1

In Wikipedia the definition for the calculation of age is described:

In German_DE :"However, the day of birth shall be included in the calculation of age"⁠Wikipedia logo v3.svg

For this case, the formula can be supplemented with +1.

Work files

The work file: 20200606_Calculating age.ods

Documentation / Manuals

Documentation / Manuals

Any questions?

For questions on this topic go to Ask.LibreOffice