Answer:
See Explanation Below
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
