Question: how to get excel to calculate number of years between two dates?
Answer: =YEARFRAC(B2, C2) Apply this formula in cell D2 and drag the fill handle to get the other calculations.