Videos/Calculating age in Calc

Foreword




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".

DATEDIF
[[Media:202006_LOENHB_Dialog box Function Wizard DATEDIF.png|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.

[[Media:202006_LOENHB_Description Function DATEDIF.png|Value for Interval]] are the expressions "d", "m", "y", "ym", "md", or "yd".

IF
[[Media:202006_LOENHB_Dialog box Function Wizard IF.png|IF(Test; Then value; Otherwise value)]]

Results in a [[Media:202006_LOENHB_Description Function IF.png|Truth check]], which is to be carried out.

TODAY
[[Media:202006_LOENHB_Dialog box Function Wizard TODAY.png|TODAY]]

Returns the current computer [[Media:202006_LOENHB_Description Function TODAY.png|system date]].

The Table
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.

Work files
The work file: [[Media:20200606_Calculating age.ods|20200606_Calculating age.ods]]

Documentation / Manuals
Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?
For questions on this topic go to:

Ask.LibreOffice

Get Involved
Join us today and help us to make it even better!

Get Involved

Donate
LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.