Date stamping when moving between sheets


Hi, I have a task list and a list of finished tasks. I want a column that stamps the date when I moved it to the list of finished task (purpose is to get stats over finished tasks last 30 days, 360 days, etc).

Attached you can see

  • Cell history when the task was moved to list of finished tasks(19.08.19).
  • Created date for the task (26.09.17)
  • Age of task in terms of days - This calculates how many days it is since the task was created, not when it was moved.

I cannot use "Modified", it is to vulnerable. There was an error displaying this embed.

Best Answer