Help with creating a schedule

syco

New member
Joined
Aug 3, 2017
Messages
2
Reaction score
0
Points
0
There are 100 employees. They all have evaluation dates - month only. Ex) Employee 1 needs an evaluation in January. I want to create a schedule that shows that employee 1 will now also need a "stay interview" in May and again in September. I would like this to be autopopulated when entering new employees and their evaluation dates.

I tried If statements but you cannot account for all 12 months (limits you at 7). How can I make this happen?
 
To be more clear... the "stay interviews need to occur 4 months later... so each year an employee gets two "stay interviews" and one evaluation all evenly spaced out. Employees have different evaluation months based on date of hire.
 
Please post a sample sheet ( no pics please) with some ( mock-up) data and expected results. Thx
 
If the hire date is in A3, then in B3 use:
=MONTH(A3)
to get the Hire Month
In C3 , use this formula to get your first "stay interview" month:
=IF(+B3+4>12,B3+4-12,B3+4)
In D3, use this formula to get your second "stay interview" month:
=IF(+C3+4>12,C3+4-12,C3+4)

Hope this helps!
 
Back
Top