Question

In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result. g

Answer 1

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,