HDTutorial
EN
How to Calculate Age of Person in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Calculate Age of Person in Excel

10,992 views November 10, 2013 1:08

Watch on YouTube
ChannelExcel, Word and PowerPoint Tutorials from Howtech

Description from the creator

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

Don't forget to check out our site howtech.tv/ for more free how-to videos!
youtube.com/ithowtovids - our feed
facebook.com/howtechtv - join us on facebook
plus.google.com/103440382717658277879 - 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.

About this tutorial

Excel, Word and PowerPoint Tutorials from Howtech published this 1:08 video tutorial on November 10, 2013. It has been watched 10,992 times on YouTube.

Duration
1:08
Published
November 10, 2013
Views
10,992
Likes
22

Tags

Share

This tutorial in other languages