# Formulas: Getting Current Age

• If you have a date entered into cell A1; 01/01/1956, and want to subtract it from cell AB;12/31/2003 how do you get it to give you a year/age (47)?

Thank You,

• Second cell is A2, not AB.

• Hi,

=YEAR(A2)-YEAR(A1) will give you the straight calc 2003 - 1956 = 47 (make sure the cell is formated to numeric not date)

if you want to find the correct age of a person try
=(A2-A1-1)/365.25
1/1/1956 to 12/31/2003 would give 47.99
1/1/56 to 1/1/2004 would give 48

Hope this helps

.....Ralph

• =A2-A1 will give you the difference in days (as an integer). So depending on how you want to calculate years there are several easy formulas

(rounded to the nearest whole year):

=round((A2-A1)/365.25,0)

or total full years (~):

=integer((A2-A1)/365.25)

The YEAR(), MONTH(), and DAY() functions will allow you to do more elaborate comparisons if you want to match exact month and days.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!