How to Make a SharePoint Calculated Date Difference Update Daily
Question details
The user needs a SharePoint date difference calculation to automatically update every day without requiring manual item modification.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Tracking the number of days since a document or list item was last reviewed by subtracting the 'Date Last Reviewed' from today's date.
- Observed behavior
- The calculated column utilizing the =TODAY() function only recalculates when the list item is updated, remaining stagnant otherwise.
Ensure you have permission to create and run Power Automate flows in your SharePoint environment, and verify the internal name of your 'Date Last Reviewed' column.
Use Power Automate to Update a Standard Number Column Daily
Since SharePoint calculated columns are event-driven and don't auto-refresh daily, using a scheduled Power Automate flow to update a regular number column is the most reliable solution.
Calculated columns in SharePoint are designed to save processing power by only recalculating formulas when an item is created or modified. Because of this, functions like =TODAY() will become outdated. To maintain a continuously changing daily value, you need to replace the calculated column with a standard number column and populate it using a scheduled cloud flow.
Navigate to your SharePoint list settings. Hide or delete the stagnant calculated column, and create a new standard 'Number' column named 'Days Since Review' to store the flow's output.
Open Power Automate, click 'Create', and choose 'Scheduled cloud flow'. Configure the flow's recurrence to run once every day at a specific time.
Add the 'Get items' action from the SharePoint connector and select your Site Address and List Name to fetch the records that need updating.
Add an 'Apply to each' control to loop through the retrieved items. Use an expression with the ticks() function to calculate the difference between the current date (utcnow()) and the 'Date Last Reviewed' value, converting it into days.
Inside the loop, add the 'Update item' SharePoint action. Map the result of your date calculation into the new 'Days Since Review' number column.
Use JSON Column Formatting for Visual Display
If you only need to display the days difference visually and do not need to filter, group, or sort by this value, you can apply JSON formatting to the date column.
Analyze Exported SharePoint Data Easily with WPS Office
While SharePoint handles your online document libraries and lists, you may frequently need to export list data for offline analysis or formatting. WPS Office offers a lightweight, high-performance, and entirely free alternative to Microsoft Office for managing all your desktop spreadsheet tasks.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Export Your SharePoint List: In SharePoint, click 'Export' and select 'Export to Excel' to download your list data.
- 3. Analyze with WPS Spreadsheet: Open the exported .xlsx file in WPS Spreadsheet to perform further date difference calculations and data analysis.

Frequently Asked Questions
Why does the =TODAY() function in a SharePoint calculated column stop updating?
SharePoint is designed to evaluate formulas in calculated columns only at the exact moment a list item is created or updated. The =TODAY() function captures the date of that specific event rather than acting as a continuously updating live variable.
Can I update a calculated column using the Power Automate 'Update item' action?
No. Calculated columns are read-only fields generated internally by SharePoint's formula engine. To update a value using Power Automate, you must direct the output to a standard column type, such as a Number or Single line of text column.
Is there a way to force calculated columns to update without using Power Automate?
You can manually edit an item or use the 'Edit in grid view' feature to trigger a bulk update, which forces SharePoint to recalculate the column. However, for a fully automated daily refresh without manual intervention, a scheduled Power Automate flow is necessary.




