Paramix Learning: Calculate Age In Spreadsheets

Calculate a Person's age in Excel, Openoffice or Libreoffice

By: Eddie Baki, 25.1.2012, 19:15

Part 1

This video shows you how to calculate a person's age given that person's birth date. Functions used:
- Day
- Month
- Year
- Today
- Datevalue
- If

Part 2

Here age is calculated with a simpler method:

1. We subtract the birth date from today's date to get the number of days between the two dates

2. The difference is divided by 365.25, the average number of days in a year, to get the approximate number of years.

3. Finally we use the function rounddown() to round the result down to a whole integer.

Please use the feedback link below for comments and suggestions.

Contact   Feedback   Just Content   Top

Copyright 2016 Paramix e. K.    Contact   Legal Details