Add the title Day of Service to cell O1, creating a formula in the remaining range to
Fantastic news! We've Found the answer you've been seeking!
Question:
Add the title "Day of Service" to cell O1, creating a formula in the remaining range to calculate how many days each employee has been with the company as of the beginning of this year Jan 01, 2023. Hint: Use the DAYS360 function. In Cell P1 type "Years of Service", creating a formula in the rest of the range to calculate how many years of service based on the Days of Service results, assuming 365 days a year, showing zero decimal places. Filter the data to show only those employees from Canada, copy this filtered data to another worksheet and name the worksheet Canadian Employees. (Be sure to paste all formulas and number formats)
Related Book For
Intermediate Accounting
ISBN: 978-0324300987
10th Edition
Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones
Posted Date: