Fix SharePoint Calculated Column Not Updating Today Automatically
Question details
A SharePoint calculated column that counts days using the current date does not refresh automatically each day.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to track the number of days elapsed from an opening date to the current date using a calculated column.
- Observed behavior
- The calculated column does not update daily; items continue to show the previous day's value until they are manually edited and saved.
Ensure you have access to Microsoft Power Automate and possess the necessary permissions to create, edit, and run scheduled cloud flows for your SharePoint list.
Use a Scheduled Power Automate Flow to Trigger Recalculation
Create a daily scheduled flow in Power Automate to update a helper column, forcing SharePoint to recalculate the item formulas automatically.
The [Today] token in SharePoint represents the day an item was created or last modified, meaning it does not act as a live clock that updates every day. To force a recalculation, the item itself must be modified.
By setting up a Power Automate flow, you can automate this modification daily. The flow will update a designated helper column with the current date, triggering your calculated columns to refresh without manual data entry.
In your SharePoint list, add a new 'Date and Time' column and name it 'HelperToday' (or similar). This column will be used to receive daily updates.
Log in to Power Automate, click 'Create' on the left menu, and select 'Scheduled cloud flow'. Name the flow and set it to repeat every 1 Day.
Add a new step and search for the 'Get items' action from the SharePoint connector. Select your 'Site Address' and 'List Name'.
Add an 'Apply to each' loop using the 'value' output from the 'Get items' step. Inside the loop, add the SharePoint 'Update item' action.
In the 'Update item' action, map the required fields. For the 'HelperToday' field, use the dynamic expression formatDateTime(utcNow(), 'yyyy-MM-dd'). Save and turn on the flow.

Manually Trigger Recalculation Using Quick Edit
If you do not have access to Power Automate, you can manually force an update by editing list items in bulk.
Need a simpler way to analyze list data? Try WPS Office
While SharePoint handles list storage and automated calculations, analyzing that exported data in complex spreadsheets is much easier with a dedicated, lightweight office suite. WPS Office provides full compatibility with Microsoft Excel formats, allowing you to manipulate list exports and date calculations without the hassle.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Export SharePoint Data: In your SharePoint list, click 'Export' and select 'Export to Excel' or 'Export to CSV'.
- 3. Analyze in WPS Spreadsheet: Open the downloaded file in WPS Spreadsheet to utilize advanced functions like =TODAY() that update dynamically without needing automated flows.

Frequently Asked Questions
Why doesn't the [Today] function work dynamically in SharePoint calculated columns?
In SharePoint calculated columns, formulas are only evaluated when an item is initially created or subsequently modified. The [Today] function does not act as a live, dynamic variable that updates on its own; it simply captures the date of the last save action.
Can I use JSON formatting to calculate days from today instead?
Yes. Column formatting using JSON allows you to display dynamic dates and calculate differences between a date column and the @now token. However, this only changes how the data is visually displayed to the user; it does not store the calculated value in the backend for complex sorting or filtering.
Will running the Power Automate flow change the 'Modified By' field?
Yes. Using the standard 'Update item' action in Power Automate will update the 'Modified' date and change the 'Modified By' field to the user account that owns the flow connection. To avoid this, advanced users can use SharePoint REST API calls within Power Automate to perform system updates without altering these tracking fields.




