Keeping Original Date in another cell
Hello, I want to copy the original ECD (estimated completion date) we set for our projects into another cell automatically while allowing the users to be able to change the ECD dates. What we want to do is set our Original ECD and then over time as we update the ECD dates be able to check the "Original ECD" date to see how far off we were from our estimate.
Is there a formula or automation we can use to set this up?
Help Article Resources
Check out the Formula Handbook template!