How to calculate age in Excel

How to calculate age in Excel

1. If we want his age in whole number years only, e.g. 40 years, then we can use this formula: =YEAR(TODAY())-YEAR(A1) 2. If we want his age in whole numbers and a fraction of a year, e.g. 40.5 years, then we can use this formula: =(TODAY()-A1)/365.25 3. If we want his age in years and months, then we can use a formula like this one: =INT((TODAY()-A1)/365.25) & ” years and ” & INT(MOD((TODAY()-A1)/365.25;1)*12) & ” months”The output of this formula will be as follows: 40 years and 2 months. 4. If we want to extend the previous formula to include days, then we can use a complex formula like this one: =INT((TODAY()-A1)/365.25) & ” years , ” & INT(MOD((TODAY()-A1)/365.25;1)*12) & ” months and ” & INT(MOD((TODAY()-A1)/30.4375;1)*30.4375) & ” days”The output of this formula will be as follows: 40 years, 2 months and 18 days. - See more at: http://www.exceldigest.com/myblog/2012/11/16/how-to-calculate-age-in-excel-2010/#sthash.8DlELHdN.dpuf