We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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

ozikl gravatar image

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

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 +0200

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 +0200

Seen: 54 times

Last updated: Sep 11 '20