How To Find Age From Date Of Birth In Excel?

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #304962

How To Find Age From Date Of Birth In Excel?

qa-featured

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.

Related Questions