Suppose A1 = date
=YEAR(NOW())-YEAR(A1)
Format the cell to number..

If this post helps click Yes
---------------
Jacob Skaria


"George Parrog" wrote:

I am trying to write a formula which shows the difference in years between
the present year and a date in another cell.