+ Reply to Thread
Results 1 to 3 of 3

How to calculate age in Excel 2010

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    4

    How to calculate age in Excel 2010

    Hello everyone. I am new to this forum. I tried to search on this but did not get any results. I have followed the help instructions on on excel but I keep getting "The formula you typed contains an error".

    Here is what the help screen says to enter:

    To calculate a person (or anything else) age you basically subtract his date of birth from today’s date. However which date functions to use depends on the amount of precision and the output format you want.

    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.

    I change A1 to G3 because that is where I the birth date.

    I'm sure that this is something simple that I am just over looking.

    Thanks for any help.

    car24winsagain

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    4,920

    Re: How to calculate age in Excel 2010

    Since you are in Houston, you should use US separators:

    =INT((TODAY()-G3)/365.25) & " years and " & INT(MOD((TODAY()-G3)/365.25,1)*12) & " months"

    More accurate is this, which better accounts for leap years:

    =DATEDIF(G3,TODAY(),"y") & " years and " & DATEDIF(G3,TODAY(),"ym") & " months"
    Last edited by Bernie Deitrick; 05-01-2014 at 09:27 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-01-2014
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: How to calculate age in Excel 2010

    Thank you for your quick reply. Both formulas worked great but I will take your advice and use the second one.

    Thanks again.

    car24winsagain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Monthly Nights On excel 2010
    By Baltyngumu in forum Excel General
    Replies: 1
    Last Post: 11-27-2013, 05:14 AM
  2. Replies: 0
    Last Post: 03-19-2013, 05:08 PM
  3. Programmatically calculate subtotals for variable groups in Excel 2010 table
    By cbeh26 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2012, 01:11 PM
  4. Trying to calculate school attendance in Excel 2010
    By barclaygp in forum Excel General
    Replies: 7
    Last Post: 08-24-2012, 10:00 AM
  5. Excel 2010 Auto Calculate Not functioning
    By yimtiaz in forum Excel General
    Replies: 3
    Last Post: 05-10-2012, 05:47 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1