Greetings,
I want a formula to calculate annual leaves for employees. I've been looking through the forums and found something similar > http://www.mrexcel.com/forum/excel-questions/677610-calculation-leave-days.html <
But the formula wouldn't suit what we're working with. I could use some changes but I'm not that versed in Excel ._.
Using Excel 2010
C3: Start date of contract e.g. 23/5/2014
D3: Calculation date e.g. 31/12/2014
F3: Total number of leave days (balance until the end date with | IF E3> X.5 THEN F3=F3+1|) The result in this case for those in 35 will be (0.681+20.417=21.098 = 21 days)
We work with 4 types of leaves per year (35, 45, 60, 30 days per year) regardless of working days/national holidays.
Right now what we're using is the simple calculations (35/12 = 2.916 per month, /30 = 0.0972 per day or 45/12 = 3.75 days per month, 3.75/30 = .125 per day etc)
I tried using the formula on the other topic but it only show leave days per month, if we entered a date in the middle of the month it'll calculate the months balance. We want it to recognize the days from X to 30 inclusive
I'm kind of new to Excel in this regard with formulas and all, any help would be greatly appreciated.
I want a formula to calculate annual leaves for employees. I've been looking through the forums and found something similar > http://www.mrexcel.com/forum/excel-questions/677610-calculation-leave-days.html <
But the formula wouldn't suit what we're working with. I could use some changes but I'm not that versed in Excel ._.
Using Excel 2010
C3: Start date of contract e.g. 23/5/2014
D3: Calculation date e.g. 31/12/2014
F3: Total number of leave days (balance until the end date with | IF E3> X.5 THEN F3=F3+1|) The result in this case for those in 35 will be (0.681+20.417=21.098 = 21 days)
We work with 4 types of leaves per year (35, 45, 60, 30 days per year) regardless of working days/national holidays.
Right now what we're using is the simple calculations (35/12 = 2.916 per month, /30 = 0.0972 per day or 45/12 = 3.75 days per month, 3.75/30 = .125 per day etc)
I tried using the formula on the other topic but it only show leave days per month, if we entered a date in the middle of the month it'll calculate the months balance. We want it to recognize the days from X to 30 inclusive
I'm kind of new to Excel in this regard with formulas and all, any help would be greatly appreciated.
