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.
Made with + in India