SharePoint Document Issues

How to Make a SharePoint Calculated Date Difference Update Daily

Jason MillerJason Miller Oct 28, 2026 869 views

Question details

The user needs a SharePoint date difference calculation to automatically update every day without requiring manual item modification.

How to Update a SharePoint Calculated Date Difference Daily
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a Standard Number Column

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.

2
Set up a Scheduled Cloud Flow

Open Power Automate, click 'Create', and choose 'Scheduled cloud flow'. Configure the flow's recurrence to run once every day at a specific time.

3
Retrieve SharePoint List Items

Add the 'Get items' action from the SharePoint connector and select your Site Address and List Name to fetch the records that need updating.

4
Calculate the Date Difference

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.

5
Update the List Item

Inside the loop, add the 'Update item' SharePoint action. Map the result of your date calculation into the new 'Days Since Review' number column.

Calculated Columns in Power Automate: You cannot select a calculated column in the 'Update Item' action in Power Automate because SharePoint treats them as read-only. Always use a standard Number or Text column for flow updates.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Export Your SharePoint List: In SharePoint, click 'Export' and select 'Export to Excel' to download your list data.
  3. 3. Analyze with WPS Spreadsheet: Open the exported .xlsx file in WPS Spreadsheet to perform further date difference calculations and data analysis.
Seamlessly open, edit, and save Microsoft Excel (.xlsx) files exported directly from SharePoint lists.Lightweight architecture ensures large data logs and spreadsheets open in seconds.Familiar ribbon interface allows you to use standard date functions and formulas without a learning curve.Completely free to use with robust formatting tools.
microsoft office alternative - wps office

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.