My manager has asked me to set up a timeroll speadsheet for 2013 because we currently keep track on paper. I currently use Excel 2010 I have set up a workbook for all full time employee. Within this workbook I have figured out my formulas for days earned which will decrease as days are used. All employees get 15 sick days a year and out of those 15 days 3 can be used as personal days. I am very confused as how to continue my formual to show if a day of personal days are used this also need to be subtracted from sick days. Below are my current formulas for sick and personal days starting in January 2013. I have also attached my workbook for better understanding.
B6=(c6-aj6)/8
Sick Days Remaining=15 sick days a year-sick days used for the month
B7=(c7-aj7/8)
Personal Days Remaining=3 Personal days a year-personal days used for the month
Please help as I have to submit this by December 2012.
Thank you,
Bookmarks