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,
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.
Don’t have an account yet? Register yourself now and be a part of our community!