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?