Hello!
I am working on a simple excel file regarding vacation usage and what I need help with is how to create what the final calculation will look like.
Here is what I am looking at:
D3 is the date of the inquiry being made (for example, May 12, 2013)
D4 is the amount of the annual accrual one earns (for example, 120)
D5 is the amount of hours the person has used thus far (for example, 16)
D6 is what remains after considering all of this (using the above factors the final result would be 24)
Each FULL month is 1/12 of the annual accrual, so, each month they earn 10 hours so using the example above the person would have earned or accrued 40 hours (they worked into May but not the full month) so they would have earned 40 hours, used 16, leaving 24. If they had worked through May 31, it would have been 5 months of accrual since that is a full month at that point. I guess how do I make D6 understand in the formula how D3 would figure into this calculation to get the appropriate end result using all this data?
Thanks!
Bookmarks