Share via

How to calculate age in years, months, and days in Excel

Anonymous
2024-11-07T18:44:03+00:00

02-06-1945 to 07-23-2021

I can get the years (76) and months (05) but what formula do I use to get the remaining days? (17)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2024-11-07T20:28:19+00:00

    With start date in A2 and end date in B2:

    Years:

    =DATEDIF(A2, B2, "y")

    Months:

    =DATEDIF(A2, B2, "ym")

    Days:

    =B2-EDATE(A2, DATEDIF(A2, B2, "m"))

    (Remark: DATEDIF(A2, B2, "md") is not 100% accurate)

    Format the cells with these formulas as General.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-27T13:38:34+00:00

    Using the DATEDIF Function:

    • Formula: =DATEDIF(StartDate, EndDate, "y")

    Using TODAY FUNCTION:

    • For current age: =DATEDIF(BirthDate, TODAY(), "y")

    If a person’s birthdate is in cell A2, you would use the formula:

    • =DATEDIF(A2,TODAY(),"Y")

    If you want to check the sample, you can download it from this link.

    1 person found this answer helpful.
    0 comments