Hot answers tagged calculated-column
The next option with you is to create a Workflow using SharePoint Designer. Run the workflow on item create and item update. Change the field FinalDate to a DateTime Create a new workflow and attach it to the List in question In the workflow using DateFunction you can add the value into a variable Use Update Current Item activity and update field ...
You will need to have 1 column to store information then another for the calculated value. Using a workflow, you would log the modified date in your first column when the status is set to complete. Then your calculated column would be something like =[Column1] - [Created]
Only top voted, non community-wiki answers of a minimum length are eligible