# How to calculate age in Excel 2010

1. ## 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. ## 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"

3. ## Re: How to calculate age in Excel 2010

Thanks again.

car24winsagain

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

#### 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