Either

=2010-LEFT(A1,4)

or

=2010-LEFT(A1,4)-1

depending on whether a part year counts

--

HTH

Bob

"NINA" wrote in message
...
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