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.https://us.v-cdn.net/6031209/uploads/771/5QCZK8WVSSSE.png