Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Age Calcs (2000)

    I have calculated an age from subtracting the Date of Birth from the Function TODAY. This works fine BUT the Age is shown as a decimal value say 45.6. I wish to convert this value into months. I know it can be done by using the MODOLO funtion but I cannot get this to work properly <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> . Help Please.

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    Anchorage, Alaska, USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Age Calcs (2000)

    Actually, you'll probably want to use Excel's built-in formula for calculating date differences (see: Mystery Function Calculates Age in Excel). Which prior to your posing this question I didn't even know that Excel had this function (I just ran a search in Google with "calculate age" and Excel as the search arguments ...

    Anyway, with a date of birth of 10/5/1952 in cell A1, using the following in B1:

    =DATEDIF(A1,TODAY(),"y")

    the result is displayed as "50". Then to get the month for age I used the following equation in C1:

    =(DATEDIF(A1,TODAY(),"m")/12-B1)*12

    which gives the month of 5 --- in otherwords a person born on October 5, 1952 is 50 years 5 months old today (3/25/2003).

    Hope this helps.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Age Calcs (2000)

    How about:

    DateDiff("m",birthdate,now)

    Steve

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    Anchorage, Alaska, USA
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Age Calcs (2000)

    I dug a little further (by following one of the links provided in: Mystery Function Calculates Age in Excel) which suggested the following example of how to calculate somone's age in year, months, AND DAYS:

    =DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months, " & DATEDIF(A1,TODAY(),"md") & " days"

    This returns a string of '50 years, 5 months, 20 days' for the aforementioned 10/5/1952 birthday and today (3/25/2003).

    The source of this suggestion is at: http://www.cpearson.com/excel/datedif.htm.

    Hope this helps even more!!!???!!!

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Age Calcs (2000)

    Thank U both. This seems to be the answer, will explore in the morning. 2255hrs now in the UK and time for bed.

Posting Permissions

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