budget formula

  1. A

    Populate Monthly Expenses Based on Date Range

    Hi all. I've tried to find something similar to this but can't quite solve it. I'm building a budget and would like to input a date range (pay date to next pay date) and have monthly expenses populate if the due date is within that date range. On Sheet1 I have a set of values with the day of...
  2. G

    Copying entire spreadsheet, but cell values link to original spreadsheet

    Hi everyone, I have a fairly large, but fairly simple spreadsheet which is used as a budget. I want to be able to create a copy of that spreadsheet, but instead of the cell values being the same, they're actually all ='Originalworkbook'!A1, for example. I want to do this because I want to...
  3. J

    Highlight a cell if another cell is highlighted

    I have built a pretty extensive budget spreadsheet with a lot of different formulas. One formula I have is when a given budget parameter such as (mortgage) is paid then that row highlights yellow so I know there is no more money available for that budget group. This is the same for groceries...
  4. J

    Pivot Table - How to copy sum value onto another sheet

    I have set up 3 excel sheets in related to budgeting/expenses. The first contains the full budget (say Sheet A for example); The second contains the expenses (Sheet B); and the Third contains the pivot table (Sheet C), which helps to group together all the different expenses from Sheet B into...
  5. B

    Work schedule budget help

    I need a formula or macro I enter a “start date” say 1/5/2022 use count +28 in a different cell I get 2/2/2022 use count +14 and get 2/16/2022 then repeat in the pattern of +28 / +14 this is how I got my work schedule for the year ( I’m a sailor )…I need to pull days worked per pay period...
  6. A

    Simple Formula for Budget Sheet

    Let's say I want to make a budget sheet of my monthly expenses. Column D are the dollar amounts I spent, and column H are the categories I bought. For example, column D is $10 and column H is labeled Food. What formula can I use to create a third column, let's say column J, which will show me...

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
Back
Top