Calculate Dates

N

NINA

Source Data coming in this format 19880716 would like to calculate the
difference in years between the source data date and the date 01/01/2010. How
would I write this formula. Appreciate anyone help--
NINA
 
B

Bob Phillips

Either

=2010-LEFT(A1,4)

or

=2010-LEFT(A1,4)-1

depending on whether a part year counts
 
Top