Excel Tracking Cell Changes - Thanks

[xiayu777]

Hello,

I have one cell call "Above" and the other one call "Below".
Sometimes, "Above" will change to "Below" and vice versa.

I want to be able to tell how many days since the cell changed from "Above" to "Below"


For example:
Cell A1 change from "Above" to "Below" on day 1------> Cell B1 = 1
Cell A1 stays the same on day 2-------------------------> Cell B1 = 2
Cell A1 stays the same on day 3-------------------------> Cell B1 = 3

Cell A1 change from "Below" to "Above" on day 4------> cell B1 = 1

I have no idea if any formula can do this or will it required some sort of coding? Thanks for your help!

 

[xiayu777]

Friendly bump.... will need this soon, any help is appreciated.