Formula doesnt work until the date

Hi,

I'm looking for a formula that wont calculate until the first of each month(i.e. projected saving for July is $1000 dollars, on 1 Aug the formula would then *activate* and I would have my over/under for the month of July based on the money I saved. I already have a running tally formula that calculates the over/under for each month to a grand total for the year

A1 is the "Goal Amount" (i.e. $1000)
B1 is the "First Deposit" of the month. (i.e. deposited $540 from first paycheck)
C1 is the "Remaining Deposit" needed to meet the goal for the month (i.e. $460 remaining)
D1 is the "Second Deposit" of the month. (i.e. deposited $470 from second paycheck)
E1 is the "Over/Under" for that month (i.e. Over $10)

Formula is repeated for each month

G2 is the running "Total Over/Under for the Year" tally

I want to be able to edit the E1 formula so it does not calculate until the 1st of the next month (i.e. July's 2015 Over/Under would not calculate until 1 August 2015) and repeat for each other month of the year.

Is it possible?

FDibbins,

=IF(E1>=EOMONTH(TODAY(),-1)+1,(B1+D1)-A1)

this would be my formula, but how would I enter the date (i.e. 1 August 2015)

Thank you for your warm greeting & quick reply. =)

E1 is a monetary value so you cannot compare it with the date. What is needed is a cell with "This month" (for each month?) e.g. 01/08/2015 which can then be compared in the formula.

For example H1 contains 01/08/2015 then in E1 put ...

=IF(EOMONTH(Today(),0)<H1,0,(B1+D1)-A1)