Determine Age in Excel with this Formula for Age Calculation

18 Feb, 2023
Paresh @Boloforms
1 min read

Create a free BoloForms account today!

Create your free account today and start creating your own digital signature.

Create Free Account

Working with dates in Excel can be tricky, especially when you want to determine the age of a person. Fortunately, there’s an easy formula for age calculation that can be used to determine the age of anyone from any given date of birth.

The formula for age calculation in Excel is simple and straightforward. All you need is the date of birth and the current date, and you can calculate the age in years, months, and days.

To start, enter the date of birth into cell A1 and the current date into cell B1. Then, enter the following formula in cell C1: =YEARFRAC(A1,B1). This formula will calculate the exact age, in years, based on the date of birth and the current date.

If you want to break it down further and determine the age in months and days, you can use the following formula: =INT((B1-A1)/365.25) & "y " & INT(MOD((B1-A1),365.25)/30.5) & "m " & INT(MOD(MOD((B1-A1),365.25),30.5)) & "d". This formula will calculate the age in years, months, and days.

Using these formulas, you can easily determine the age of any person from their date of birth. It’s important to note that these formulas only work when the dates are entered in the proper format.

Limited-time offer
Get lifetime access to BoloForms Signatures for FREE!
Includes :
Collect Signatures inside Forms (5 submissions/mo)
Send for Signature (1 document/mo)
5 Forms- Generate Custom PDFs based on Form Submissions
1 PDF Template
Free Contracts Templates
24/7 support
Notifications and Reminders
Audit Log and History
BoloForms Signature Branding

(act fast as this exclusive offer won't last forever!)

Free Forever
No credit card required