# Monthly deduction formula

#### Lawless147

##### New Member
Hi,

What I a after if possible please is a formula where it can work out how much money is left that month.
I would like to enter an "income" (that is variable) figure in a cell and in a return cell get how much of that is left depending on today's date with any upcoming bills for that month deducted.

I have tried using SUMIF and TODAY formulas but can not seem to piece the right combination together.
I have also tried using DAY to make todays date into a numerical number of 1-31 and do it that way aswell but still no joy.
=SUMIF(B1:B5,"<=D1",A1:A5)
B is Due date of bill
D is todays date changed into a number using DAY so today is 3
A is the value

Example
The date is today the 3rd of the month
Input In the income cell £100
There is 2 bills that came out on the 1st so these don't need deducting.
3 bills of £10,£20,£30 come out on the 15th so a total of £60 needs deducting.
I would like a results cell to return me £40

I have tried to explain best I can.

Any help appreciated

Thanks Simon

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### tyija1995

##### Well-known Member
Re: Help with a monthly deduction formula

Hey,

=SUMIF(B1:B5, ">="&D1,A1:A5) would return 60, then you can subtract that from the 100 to get 40.

#### Lawless147

##### New Member
Re: Help with a monthly deduction formula

I was missing the & in the middle thanks for that

Replies
4
Views
157
Replies
3
Views
108
Replies
2
Views
241
Replies
7
Views
59
Replies
1
Views
93

1,129,557
Messages
5,637,040
Members
416,955
Latest member
Gohar hussain

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

### Which adblocker are you using?

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

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