SharePoint Document Issues

How to Fix a SharePoint Calculated Date That Does Not Change

Steve K Oct 12, 2026 869 views

Question details

The user needs to correct a SharePoint calculated column that fails to add a specific review period to the creation date.

How to Fix a SharePoint Calculated Date That Does Not Change

Product: SharePoint
Device & OS: not provided
Scenario: Creating or updating a calculated date column to automatically determine a future review date based on the item's creation date.
Observed behavior: The calculated column returns the exact same date as the Date Created value instead of correctly adding the multi-year review period.

Before you start

Verify that the variable column you are referencing (such as ReviewPeriod) is formatted as a Number column, and ensure you have sufficient permissions to modify list or library settings.

Solution 1Recommended

Use the Precise DATE Function Formula

This is the most accurate method to add years to a date in SharePoint, as it properly accounts for leap years and maintains the exact month and day.

SharePoint allows you to manipulate date components individually using the YEAR, MONTH, and DAY functions. By extracting these components from the Date Created and adding your review period directly to the YEAR value, SharePoint calculates the exact future date flawlessly.

Navigate to List Settings

Open your SharePoint list or library, click the Gear icon in the top right corner, and select List settings or Library settings.

Edit the Calculated Column

Scroll down to the Columns section and click on the name of your calculated column to open its properties.

Enter the Correct Formula

In the formula box, input the following: =DATE(YEAR([Date Created])+ReviewPeriod,MONTH([Date Created]),DAY([Date Created]))

Configure the Output Data Type

Under 'The data type returned from this formula is', select either 'Date and Time' or 'Date Only', then click OK to save your changes.

Check Column Names: If your column names contain spaces, make sure they are wrapped in square brackets, such as [Date Created].

Solution 2

Use the Approximate Day-Based Formula

A simpler alternative formula if exact leap year precision is not strictly required for your document review dates.

Free Microsoft Office alternative

Manage Your Documents Effectively with WPS Office

While resolving complex SharePoint formulas on the server side, you also need a reliable desktop office suite to create, edit, and review your documents. WPS Office is a free, lightweight, and user-friendly alternative to Microsoft Office that supports seamless file handling.

1. Download and Install: Visit the official WPS website to download the free installer and follow the on-screen instructions.
2. Open Your Documents: Launch WPS Office and easily open your exported SharePoint documents or local Office files.
3. Edit and Save: Use the familiar interface to edit your spreadsheets and documents, saving them in standard Microsoft Office formats seamlessly.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight software footprint with lightning-fast installation and launch times.Familiar tabbed user interface, ensuring zero learning curve for new users.Built-in PDF editing tools for comprehensive document management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my SharePoint calculated date show up as a number like 44200?

This happens when the calculated column's return data type is accidentally set to 'Number' or 'Single line of text'. To fix it, edit the column settings and change 'The data type returned from this formula is' to 'Date and Time'.

Can I use [Today] in a SharePoint calculated column?

SharePoint does not natively support using [Today] or [Me] in calculated columns to create a dynamic, daily updating value. Calculated columns are only triggered and recalculated when an item is created or updated.

What happens if my column name doesn't have spaces?

If your custom column name lacks spaces (e.g., ReviewPeriod), you do not need to enclose it in square brackets within the formula. Only column names with spaces or special characters require square brackets.

Document & File Issues