MM/DD/YYYY-YYYY=? Date Subtraction

[jiminoregon]

This should be easy...but apparently I'm Excel challenged...

I have a date box that displays MM/DD/YYYY. I have another box that displays only the year.

I'm trying to take MM/DD/YYYY-YYYY=# of years.

For example 03/28/2009-2005=4 years.

2 hours into this I've been able to come up with everything but the right answer...any help appreciated.

Thanks,

Jim

 

[ZVI]

VBA solution for string variables:

<font face=Courier New>
Sub Test()
  Dim txt1, txt2
  txt1 = "03/28/2009"
  txt2 = "2005"
  MsgBox Val(Split(txt1, "/")(2)) - Val(txt2)
End Sub</FONT>

For date (not string) cells try formula:
=YEAR(A1)-A2
where A1 is the 03/28/2009 date value
A2 is the 2005 numeric value

 

[jiminoregon]

VBA solution for string variables:

Sub Test()
  Dim txt1, txt2
  txt1 = "03/28/2009"
  txt2 = "2005"
  MsgBox Val(Split(txt1, "/")(2)) - Val(txt2)
End Sub

For date (not string) cells try formula:
=YEAR(A1)-A2
where A1 is the 03/28/2009 date value
A2 is the 2005 numeric value

Thank you so much... =YEAR(A1)-A2 works perfectly!

Jim