Hello, this should be easy, but I'm having trouble nonetheless:

Cell C6 receives a date in this format: December 4, 2012
Cell C7 receives data in this format: 3 Years

I need a macro for my button to add the number of years in Cell C7 to the date in Cell C6 and display the date into Cell C8.

How do I do this?