Use the YEARFRAC function to work out how many years difference is there between the date 1980-07-31 (31 July 1980) and 1998-05-02 (2 May 1998) (to 1 decimal place)?

17.7 Years

Explanation:

YEARFRAC is a function in Microsoft Excel that returns the year fraction representing the number of whole days between a particular start date and an end date.

A typical view of the function is:

=YEARFRAC(start_date, end_date, [basis])

All that needs to be done is

1. Type in the equal to sign(=) in the cell you want your answer,

2. Type in YEARFRAC and open your bracket,

3. Input your start date and end date, close your bracket and press enter.