Assuming the 19880716 to be in Cell A1, use:
=2010-left(A1,4)
--
Thanx & Best Regards,

Faraz!


"NINA" wrote:

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