Leave Schedule - Excel VBA

[YantiPrima]

Hello,

I need some help to make a leave schedule plan based on the date an employee is joining.
Employee name = column C
Joining date = column D
Data start in row # 3
Column D to column BDJ is date, starting from Jan 1, 2018 to Dec 31, 2021

Below the conditions:
Employee entitle for rotation off if employee has been working for 70 days
Employee get rotation off for 14 days

What I need:
Based on cell value on column D, joining date
1. 70 days after joining date, the column will be colored with red background
2. The red background color will be 14 days or equal to 14 columns referring from the first day of employee's leave,
3. It should be repeated to another columns based on conditions 1 & 2 above

Example:
If an employee is joining on Feb 2, 2018 (column D) then
after 70 days working, until Apr 12, 2018
Employee will get 14 days leave, starting from Apr 13, 2018 until April 26, 2018
The color on that row, along 14 days or 14 columns will colored in red background
And will be continue until Dec 31, 2021 at column BDJ

To me, it is really impossible to write the code, but I do believe this forum having an arsenal code that could help me.

Best regards,
PrimaSatria