Call off template | Human Resource Management homework help

I need to create an excel where I can only track the days’ employees call off work. They are only allowed to call off 3 times within any 30 day period. Need formulas in place to change the fields to yellow when they are 2 days off within 30 day period and red when they are 3 days off within a 30 day period. 

1. A column for employee names

2. Only record dates of call-offs (not the whole calendar) 

3. Employee Name field to change color to yellow when 2 call-off dates are within a 30-day period

4. Employee Name field to change color to red when 3 call-off dates are within a 30-day period

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.