Assistance adding extra functions and formulas

I have this employee tracker, I'm sure you have seen it before. I just need it "tweaked" to me specifications.

I've highlighted in red the areas im looking at. Basically I would like the Statutory Holidays highlighted only as the staff work on these days and accrue the holiday for a later date.Also if possible to insert an accrual function which would show annual leave earned at the end of each month.A column with carried over from 2016 in Employee Report Or Team Dashboard and included in the formulas would be great. I hope i have explained enough if not please feel free to ask.
You time and knowledge much appreciated.

No, not really. You have not given any indication about the type of formula you are looking for, but, in the hope that others can see what you need, I will remove the moderation request.