Finding # of years between 2 dates

[Iceberg]

Hello!

I am trying to write a bit of code to find the number of years between 2 columns of dates. I have one set of dates in Column D, another in E, and I would like the results to post in Column G.

Here's what I tried:

For I = 2 To J
  Let Range("G" & I).Value = Range("E" & I).Value - Range("D" & I).Value
Next I

It works, but it gives me the number of days instead of the number of years.

Thanks in advance...!

 

[Jonmo1]

Try this

For I = 2 To J
  Let Range("G" & I).Value = Year(Range("E" & I).Value) - Year(Range("D" & I).Value)
Next I

Hope this helps.

 

[Iceberg]

Works like a charm! Thanks for your help!

 

[eblake]

Try this:

For I = 2 To J
    If Year(Range("E" & I).Value) > Year(Range("D" & I).Value) Then
        Range("G" & I).Value = Year(Range("E" & I).Value) - Year(Range("D" & I).Value)
    Else
        Range("G" & I).Value = Year(Range("D" & I).Value) - Year(Range("E" & I).Value)
    End If
Next I