# 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  Register To Reply

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"  Register To Reply

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

Thanks again.

car24winsagain  Register To Reply