Question

On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20.

Answer 1

See Explanation Below

Step-by-step explanation:

The question is missing some details.

To answer this question, I'll make the following assumption

The assumption is that Cell B8 contains the date which a worker commence work in the organization.

Working base on the above assumption; in cell c8, type the following

= DATEIF(B8,TODAY(),"Y")

The above function follows the syntax below.

=DATEDIF (Start_Date , End_Date , Unit )

Where B8 = Start_Date = Date of work commencement

The function TODAY() returns today's date and it represent End_Date

The unit is represented by Y which means that the function is to return the number of years.

To copy the function to range C9:C20.

Select the cell C8

Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:

Drag the fill handle down to C20