## Determine Age in Excel with this Formula for Age Calculation

Learn how to determine age in Excel with this formula for age calculation. Understand the formula for calculating age in years, months, and days, as well as the proper format for entering dates. An easy guide to mastering age calculation in Excel.

### Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

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.

### Paresh Deshmukh

Co-Founder, BoloForms

18 Feb, 2023

## Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.