# Thread: Age Calcs (2000)

1. ## 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. ## 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. ## Re: Age Calcs (2000)

DateDiff("m",birthdate,now)

Steve

4. ## 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. ## 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
•