How to stop formula happening until corresponding date in another column passes?

[ozikl]

I am setting up a budget and daily spend calculator but am having trouble because my calculations for money not spent from a daily budget includes days that haven’t passed yet and therefore money is put into a “saved” box that isn’t really saved because it is budgeted for another day in the future.

Is there a way i can stop a formula in column C from happening until the corresponding date in column A has passed?

I have included a couple of screenshots to help demonstrate what I’m talking about.

Any help to fix this is greatly appreciated.

[LeroyG]

Paste in D3: =IF(NOW()<A3;"";D2+B3). Copy downward dragging the fill handle or with Ctrl+C, select, Ctrl+V.

---

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark () to the left of the answer that solves your question.