Home Forums Pension Seven types of age calculation and how to do these using Excel

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #5640
    Richard Purvey
    Participant

      Calculation of Age On Last Birthday using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2, and into cell C2, put the formula =DATEDIF(A2,B2,”Y”)

      Calculation of Age On Next Birthday using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2, and into cell C2, put the formula =DATEDIF(A2,B2,”Y”)+1

      Calculation of Age In Years and Whole Months using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2.  Into cell C2, put the formula =DATEDIF(A2,B2,”Y”) and into cell D2, put the formula =DATEDIF(A2,B2,”YM”)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Calculation of Age In Years and Days using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2.  Into cell C2, put the formula =DATEDIF(A2,B2,”Y”) and into cell D2, put the formula =DATEDIF(A2,B2,”YD”)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Calculation of Age In Years, Months and Days using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2.  Into cell C2, put the formula =DATEDIF(A2,B2,”Y”) and into cell D2, put the formula =DATEDIF(A2,B2,”YM”) and into cell E2, put the formula =DATEDIF(A2,B2,”MD”)

      Also;                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Calculation of Age On Nearest Birthday using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2, and into cell C2, put the formula =DATEDIF(A2,B2+183,”Y”)

       

      The 183 whole days added to B2 in this formula are half of the average number of days in a year (365.2425 days), and so this calculation will, ON AVERAGE, be exact.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Calculation of Age In Years and Months (To The Nearest Month) using excel.  Put the date of birth into cell A2 and the relevant later date into cell B2.  Into cell C2, put the formula =DATEDIF(A2,B2+15,”Y”) and into cell D2, put the formula =DATEDIF(A2,B2+15,”YM”)

       

       

      The 15 whole days added to B2 in these formulae are half of the average number of days in a month (365.2425 days divided by 12), and so these calculations will, ON AVERAGE, be exact.

       

       

       

       

       

       

       

       

       

      #25287
      Harry Peter
      Participant

        To calculate age in Excel using an age calculator, you can use these formulas for different scenarios. For age on the last birthday, apply =DATEDIF(A2, B2, “Y”). If you need to determine age on the next birthday, use =DATEDIF(A2, B2, “Y”)+1. To find age in years and months, use =DATEDIF(A2, B2, “Y”) for years and =DATEDIF(A2, B2, “YM”) for months.

        For calculating age in years and days, use =DATEDIF(A2, B2, “Y”) for years and =DATEDIF(A2, B2, “YD”) for days. To get age in years, months, and days, use =DATEDIF(A2, B2, “Y”) for years, =DATEDIF(A2, B2, “YM”) for months, and =DATEDIF(A2, B2, “MD”) for days.

        #25288
        Harry Peter
        Participant

          For age calculations in Excel, use these formulas: =DATEDIF(A2, B2, “Y”) for years, =DATEDIF(A2, B2, “YM”) for months, and =DATEDIF(A2, B2, “MD”) for days or you can try another online tool Excel Age Calculation to do all this in a minute.

        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.