accrual

  1. B

    calculating vacation accrual to date

    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...
  2. C

    formula required!

    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...
  3. M

    Vacation Accrual

    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...
  4. C

    Multiple Criteria Accrual Vlookup with Greater Than or Equal To

    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...
  5. D

    Calculating payments-multiple disbursements

    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...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top