Forum Discussion

Sag771's avatar
Sag771
Copper Contributor
Sep 18, 2024

How to set up Formula to determine my aged in a given Year

I am trying to set up a spreadsheet in Excel to determine a person's age in a given year. For example, if I was born on 04/27/1956, how old would I have been in 1994, or how old would I be in 2047? Any help would be greatly appreciated,

Sag771

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    maybe:
    =INT(YEARFRAC( [date of birth] , [date of year in question] )
    this will uses references to a cell with your date of birth and a cell with a date you want to know. It will account for what day in that year you want to know. So if your DOB is 12/12/2000 then any day before 12/12 will be 1 less than any day >=12/12. To only account for the year then set the day to be 1/1 for that year. For example:
    =INT(YEARFRAC( [date of birth] , DATE( [year], 1,1 ) )
    or in this case simply
    = [year] - YEAR( [date of birth] )

    • Sag771's avatar
      Sag771
      Copper Contributor
      Thanks! I will work on your suggestion and get back with you,

Resources