Forum Discussion
Use modified dates not originals
Hi Pricey79
Based on the description of your issue, it seems that the calculation for the "Duration" column might be referencing a static value or not updating dynamically with changes to the "Original" date.
Please try the following:
Ensure Dynamic Calculation for Duration：
Ensure your formula is correctly set up.
=DATEDIF([Original], [New], "d")Workflow or Power Automate:
If the above does not resolve the issue, consider using SharePoint workflows or Power Automate to update the "Duration" column.
You can create a workflow or an automation that triggers on item update, which recalculates the "Duration" based on the current values of "Original" and "New" columns.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Pricey79
Based on the description of your issue, it seems that the calculation for the "Duration" column might be referencing a static value or not updating dynamically with changes to the "Original" date.
Please try the following:
Ensure Dynamic Calculation for Duration：
Ensure your formula is correctly set up. =DATEDIF([Original], [New], "d")
Workflow or Power Automate:
If the above does not resolve the issue, consider using SharePoint workflows or Power Automate to update the "Duration" column.
You can create a workflow or an automation that triggers on item update, which recalculates the "Duration" based on the current values of "Original" and "New" columns.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you 🙂