Is there a way to monitor(watch) cell value changes w/o Watch window? Office2013. I have cell in witch i input raw data like let's say number 12345, i need formula or VBA sub to watch value changes and display me in other cell, date when was change occured, or if it's possible, days passed from change. Example: 12345 number was entered 20.5.2016., need to display days passed from 20.5.(18 days).
Thanks in advance. Thank you for your time and love for Excel!
P.s And if it's possible, non-volatile way. Thanks