How To Find Age From Date Of Birth In Excel?

Asked By reyer julio 10 points N/A Posted on - 10/22/2017

Hello everyone,

I have a record of my students with their date of birth but, I need to age the age. But it seems really long process. Do excel provide any function or shortcut to find age from date of birth quickly.

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

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: date of birth | Excel

Answered By Kenneth D Morgan 0 points N/A #304962

How To Find Age From Date Of Birth In Excel?

Yes, there is a function through which you can quickly calculate the age.

First populate your date of birth column and create column for age.

Use formula =DATEDIF(A2,NOW(),”y”) to convert the DOB to time.

Another method to find out the desired information is use of rundown function.

Or you can subtract the DOB from current date. For that you need to provide the current date.

About Kenneth D Morgan

Questions
6

Answers
22

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/22/2017
• Question Category: MS Excel