Is there a formula to express the net change in the value of a cell on daily basis?

Question

I have a cell whose values changes on daily basis because of the changes different departments make in the source sheet. I want to know how much the cell value has increased or decreased on a daily basis - the net change in the value of that cell. In other words, I want to subtract yesterday's value of that cell from its today's (latest) value and return the difference in another cell.

Please help me with the formula to do this. Thanks a lot.

nikolinode · Answer

sohailzamani&nbsp;Maybe through this information first determine the change and then the desired mean value with a formula ... is just one thought.How to run a macro when certain cells change in Excelhttps://docs.microsoft.com/en-gb/office/troubleshoot/excel/run-macro-cells-change&nbsp;I would be happy to know if I could help.NikolinoI know that I don't know (Socrates)

sohailzamani · Answer

Great thanks&nbsp;NikolinoDE&nbsp;&nbsp;I'll try this solution and see if that works for me. 🙂&nbsp;Regards,Sohail Zamani

sohailzamani · Answer

Will the same work in Google Sheets as well?

Forum Discussion

Is there a formula to express the net change in the value of a cell on daily basis?

3 Replies

How to run a macro when certain cells change in Excel

Resources