N/APosted on - 10/22/2017
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.
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.