How to calculate age from DOB in Excel

Excel users frequently want to calculate age from date of birth. You can do this with a few simple steps in Easy Data Transform:

calculate age from DOB Excel

convert DOB to age Excel

return new Date() - new Date( $(DOB) );


But replace DOB with the name of your date of birth column. Click Evaluate. The Age column should now show the difference (in milliseconds) between the current date and the date of birth.

convert from DOB to age Excel

Excel date of birth to age

Excel calculate age from DOB

convert date of birth to age in Excel

calculate age from birthdate in Excel

Easy Data Transform allows you to combine multiple transforms to quickly and easily create many different data transformations. If you have large number of files to convert you can do it using the batch processing feature.

Try it free now!

Windows Logo Windows Download

v1.19.1 for Windows 10 / 8 / 7 (37 MB)

Apple Logo Mac Download

v1.19.1 for Mac 11.x to 10.13 (38 MB)


Questions or problems?

Email support@easydatatransform.com