Hi there!
I am looking to track outgoing calls for our call center daily automatically.

I have sheet right now that automatically updates when a call is made (a value is changed within one of my agent's excel lists and my list counts it). I would like to track the amount of calls made by each agent daily automatically within different cells. I've seen data validation used to limit data entered after a certain date, though when I try to to limit data using this feature on a linked cell, the content will still update. Is there a way to "freeze" content entered into a cell after a certain date, even if the cell is updated through a formula or while linked from a different cell?

Thanks so much for the help,

Mike.