Monthly deduction formula

[Lawless147]

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

 

[tyija1995]

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]

Re: Help with a monthly deduction formula

I was missing the & in the middle thanks for that