Calculating age in Calc – LibreOffice 6-4
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
See picture on the right "The formula".
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".
See picture on the right "View of the table from 07.06.2020".
Age calculation - Wikipedia +1
In Wikipedia the definition for the calculation of age is described:
For this case, the formula can be supplemented with +1.
The work file: 20200606_Calculating age.ods
Documentation / Manuals
For questions on this topic go to Ask.LibreOffice