accrual

Hi everyone :), I have a spreadsheet where our dept. tracks vacation time taken / planned. How do I create a formula where it can show vacation accrued to date...:confused: accrual rate is .22 p/day or 1.54 wk I want it to calculate the weekly accrual to current date ie... 1/1/12 to...

Please I want some assistance with certain formulas. J2 Used Vacation Days. E2 Unused Vacation from Two Years Ago F2 Unused Vacation from Last Year H2 Remaining Vacation Days (this year) I have Starting date of Employee in C2 Date till today in D2 The Used Vacation...

Hello, I have been trying to figure this out for days it is time to move on to a new chapter in my life. Could someone please see if they have any advice? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to figure out how to accrue...

Hi Everyone, I need a bit of help. I have a sheet that looks up accrual rates for employees based on length of service and is supposed to come up with the right accrual rate. It doesn't. I've tried INDEX MATCH, SUMPRODUCT and Vlookup and keep falling flat. Basically it's like this A B C D...

I am giving a loan with a large initial disbursement, and then once certain contingencies are met, there are other disbursements. Payments won't start until next year, and then will be quarterly. (The assumption is that all the disbursements will happen before payments start.) I am trying to...