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

Read the passage from Of the Wisdom of the Ancients. This Love is introduced without any parent at all; only, that some say he was an egg of Night. And himself
Please answer NO LINKS PLEASE
A garden has an area of 32 square feet. What is the smallest possible perimeter of the garden? brainliest if correct
Which of the following best describes Samuel Gompers’s role in relation to the goals of organized labor?
Help! Will Give Brainliest!!!!
irregulares tu informales for hacer, tener, and venir
What are the abiotic factors the characterize a forest ecosystem
Six is fifteen less than three time a number
NO LINKS OR WILL PLE REPORTED!! WILL GIVE BRAINIEST!! In the given figure, can you conclude r || s? A. The lines are parallel because the given angles are same
small grasses are usually the first plants to appear in an area after a disturbance. these grasses are an example of which type of species?! HELP