The excel formula to calculate age.

Asked By William D Ayala 0 points N/A Posted on - 06/05/2020

Hello, I am a novice in using Excel. I want to know how to use the excel formula to calculate age. Reply ASAP. Thanks in advance.

• Status:
• Question Views: 34
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Others

Best Answer by

Go To Solution

Answered By Monteno Gara 0 points N/A #329818

The excel formula to calculate age.

Hi, I will explain the excel formula to calculate age. To do so, we use the DATEDIF Function. With this function, the age of a person is calculated. An example of use would be DATEDIF(“12/1/1989”, TODAY(), y), which calculates the age of a person in years approximately.

About Monteno Gara

Questions
1

Answers
8

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/05/2020
• Question Category: Others