Results 1 to 2 of 2

Thread: Calculate age

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Calculate age

    Could someone please help!

    I am trying to figure out the person's age as of today. I can figure out the years no problem, but of course, if the person's birthday has not happened yet, it is still saying they are the age they WILL be. Not the age they are.

    i.e.

    if you were born on 10/1/72, you have not yet turned 36. Tomorrow you will be 36 years old. Today you are still 35. However, my calculations: =Year(Today())-Year(A1), shows a calculation of 36.

    Help!

  2. #2
    Join Date
    Dec 2003
    Posts
    138
    If anyone is interested I found several answers, but the easiest was:

    To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.

    =DATEDIF(birthdate,date,"y")

    from:

    http://excel-formulas.blogspot.com/2...-in-excel.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •