BIS 155

Date, Logical and Lookup Functions (Chapter 7): From the Logic-Lookup worksheet, let's practice using the YEARFRAC function. In cell F7, create a formula to calculate how many years Rush has worked at the company. Calculate for all employees in Column F. You will need to use the Decrease Decimal feature to decrease to one decimal place.

Discuss the YEARFRAC function. Share your formula with the class and how you created it. How can you quickly calculate years worked for the rest of the employees without entering the formula row by row?