Question

Create a formula using the name ranges that adds the amount of days worked for each staff person given their hire date.

b) Add that formula to column E for each person.
c) Create a formula using the name ranges that adds the total number of years (to two decimal places) for each teacher and adminstrator based on their hire date.
d) Add that formula to column F for each person.

Answer 1

To add the amount of days worked for each staff person based on their hire date, you can use the following formula in column E:

`=TODAY()-[Hire_Date]`

This formula subtracts the hire date (stored in the range [Hire_Date]) from the current date (using the TODAY() function) to calculate the number of days worked.

To add the total number of years (to two decimal places) for each teacher and administrator based on their hire date, you can use the following formula in column F:

`=YEARFRAC([Hire_Date],TODAY(),1)`

This formula calculates the fraction of years between the hire date and the current date, using the YEARFRAC() function with a basis of 1 (which counts the actual number of days in a year).

Please make sure to replace [Hire_Date] with the actual range containing the hire dates of each staff person.