How to Calculate Age of Person in Excel

In this tutorial you will learn how to determine a person's age in Excel.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
   / ithowtovids   - our feed
  / howtechtv   - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

In this tutorial you will learn how to determine person's age in Excel.

Prerequisites: Microsoft Excel.

Step 1. Launch Excel and create a new document.

Step 2. Type in the birthdate of the person you want to calculate age for, in the format dd/mm/yyyy.

Step 3. Position the cursor in the cell you want to put your result to.

Type in the following formula =INT((TODAY()-A)/365.25),

where A is the cell with the birthdate of the person. Hit „ Enter".

Result: Congratulations, you have now learnt how to determine a person's age in Excel.