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

Which answer best describes one way that territorial gains affected the United States? They created a large national debt. They brought renewed conflict with Br
how can NSTP CWTS students service the community?​
What role do exacutive agencies play in developing the federal budget
HELP! After finding area explain the reasoning you used to find the area and I’ll give brainliest!
The info is in the picture
What effect did the Industrial Revolution have on children and workers in Great Britain? explain in 2–3 sentences. explain what it tells you about the Industria
If a/b= 8 and ac -5 = 11, then bc =?
This is my GCSC revision! IN DETAIL PLS describe how microbes reproduce!!
What kind of words would you use to describe your relationship with the Holy Spirit? Fire? Power?
what physical feature of Vietnam was most useful to guerilla fighters’ tactics during the vietnam war