0
How do you write an Excel spreadsheet formula to determine an employees years of service based on their start date when you need to round the year up if more than 6 months?
Wiki User
∙ 13y ago
- Enter employee's name in A1 (e.g., Bob).
- Format Cells A2 and A3 as dates (your choice of formats).
- In cell A2 enter employee's start date (e.g., 4/1/2005).
- In cell A3 enter the formula =TODAY(). [This enters today's date and will allow you to evaluate year's of service in real time.]
- In cell B3 enter the formula:
= A1 & " has been employed for " & ROUND((A3-A2)/365,) & " years."
- [Bob has been employed for 4 years.]
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
When was Service Employees International Union created?
Service Employees International Union was created in 1921.
When was Confederation of Health Service Employees created?
Confederation of Health Service Employees was created in 1946.
When was Civil Service Employees Association created?
Civil Service Employees Association was created in 1910.
When was National Weather Service Employees Organization created?
National Weather Service Employees Organization was created in 1976-07.
How do you write an Excel spreadsheet formula to determine an employees years of service based on their start date?
Enter employee's name in A1 (e.g., Bob).Format Cells A2 and A3 as dates (your choice of formats).In cell A2 enter employee's start date (e.g., 4/1/2005).In cell A3 enter the formula =TODAY(). [This enters today's date and will allow you to evaluate year's of service in real time.]In cell B3 enter the formula: = A1 & " has been employed for " & DATEDIF(A2,A3,"y") & " years."[Bob has been employed for 4 years.]==========If you want to add more fidelity, enter the following formula in cell B3:= A1 & " has been employed for " & DATEDIF(A2,A3,"y") & " years and " & INT((A3-A2)/7)-DATEDIF(A2,A3,"y")*52 & " weeks."[Bob has been employed for 4 years and 43 weeks.]
Is the Business employees are not directly related to the quality of a business product or service?
Business employees are not directly related to the quality of a business product or service
What do many employees offer to employees for completing customer service training classes?
promotions
What is SEIU?
Service Employees International Union
Government employees as a group?
civil service
What benefits does US Postal Service offer to employees?
Employees of the United States Postal Service are able to opt into the Federal Employee Health Benefits program. Additionally, employees are eligible for pension plans.
What the role of customers as partial employees?
Customer's buying behaviors signal to the company what is in demand and what isn't. They also help the business determine what aspects of customer service is most effective and what isn't working.
How can you assess customer needs for urgency to determine priorities for service delivery?
determine priorities for service delivery
