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

[sohailzamani]

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.

[#2]

@sohailzamani 

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 Excel

https://docs.microsoft.com/en-gb/office/troubleshoot/excel/run-macro-cells-change

I would be happy to know if I could help.

Nikolino
I know that I don't know (Socrates)

[#3]

Great thanks @NikolinoDE 

I'll try this solution and see if that works for me. :)

Regards,

Sohail Zamani

[#4]

Will the same work in Google Sheets as well?