Stop formula in excel

[deep123]

Hi,

Is there a way to stop running the formula in a particular cell
For eg:
Date Column B
31-08-2016 1000
30-09-2016

Value in column B changes every day and it is from another sheet .
I would like to run the formula only if today()<=31-08-2016 otherwise save previous day value.
TIA

 

[Michael M]

what formula is currently in B ?

 

[deep123]

what formula is currently in B ?

Sumof another column in sheet 2, that too changes daily

 

[Michael M]

that too changes daily

In that case I believe you will need to process the data by VBA as once the sum of the other sheet has been calculated the old data is overwritten

 

[deep123]

In that case I believe you will need to process the data by VBA as once the sum of the other sheet has been calculated the old data is overwritten

Yes.
Can you please help me in this.
Any reference