Answer:
The cell G8 in the summary worksheet can be filled with the help of the date function (YEARFRAC) as follows:
The required formula to calculate the number of years between cell H2 and last remodel date in the Last Remodel column cell F8 is given as follows:
G8 =YEARFRAC($H$2,F8)
The above formula will return value 13.75 into the cell G8. The sample result is shown as follows in the images attached,
