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

do you think it is possible to be a benevolent slaveholder
how do you do equations and equalities on a number line
The grapgh of f(x)= 2^x +1 is shown below. Explain how to find the average rate of change between x=0 and x=3
y=8x+25, where x is hours . what is the y-intercept
Why did Britain and France declare war on Germany? Germany invaded Poland. Germany invaded France. Germany bombed England. Germany bombed France.
what might have been the outcome of a successful invasion of laos in 1971?
Which of the following is a personal benefit of the value of the social connections you make in college?A. The fraternity and sorority systemB. Living in colleg
HELP.....+ will give brainiest
How might a political party leverage public debate in its favor?
What is the main motivation for any business to sell products??