Monthly deduction formula

Lawless147

New Member
Joined
Nov 5, 2018
Messages
5
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
Joined
Feb 26, 2019
Messages
780
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Nov 5, 2018
Messages
5
Re: Help with a monthly deduction formula

I was missing the & in the middle thanks for that
 

Watch MrExcel Video

Forum statistics

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