patrymm4808 patrymm4808
  • 25-01-2021
  • Computers and Technology
contestada

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)?

Respuesta :

Emela
Emela Emela
  • 29-01-2021

Answer: 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.

Answer Link

Otras preguntas

Taylor is going on a road trip that is 600 miles long. Her friend recommends that she buy engine oil A because it will save her 60 cents in gas for every 20 mil
A .105-kg hockey puck is moving at 49 m/s is caught by a 75-kg goalie at rest. With what speed does the goalie slide on the ice?
what is 5/8x+4=3/8x+12​
two friends travel 150 km and 200 km in time 6 hours and 5 hour respectively. what is the ratio of their average speed?​
3^x + 5.3^x = 54 What is the value of x
718 is what % of 847​
The dimensions (width and length) of room1 have been read into two variables: width and length 1. The dimensions of room2 have been read into two other variable
What number is 80% of 90? Numerical Answers Expected! Answer for Blank 1:
why did some of the native people convert?
Match the explorer with his accomplishment. 1.Magellan discovered rich fishing grounds 2.Cartier