Ask Your Question

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

asked 2019-05-29 14:37:23 +0100

ozikl gravatar image

updated 2019-05-29 14:38:06 +0100

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.

image description

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-09-11 01:24:05 +0100

LeroyG gravatar image

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 (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-29 14:37:23 +0100

Seen: 49 times

Last updated: Sep 11 '20