SharePoint Document Issues

How to Fix Calculated Date Missing from Microsoft Lists View

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs to resolve an issue where a calculated date value is invisible in Microsoft Lists and SharePoint views but appears normally in the edit form.

Fix a Calculated Date Missing from a Microsoft Lists View

Product: Microsoft Lists / SharePoint
Device & OS: not provided
Scenario: Viewing a calculated date column in a Microsoft Lists or SharePoint list view.
Observed behavior: The calculated date displays correctly in the edit form but remains entirely blank in the list view. Text-based calculations work, but converting them back to a date using the DATEVALUE function fails to display.

Before you start

Ensure you have sufficient permissions to edit list columns and views in SharePoint or Microsoft Lists. It is also recommended to test the issue in an incognito or private browsing window to rule out browser cache problems.

Solution 1Recommended

Adjust Column Formatting Settings

Modifying the column formatting styles can resolve display issues caused by hidden fonts, transparent colors, or incorrect date rendering.

Sometimes, the modern list view struggles to render calculated date values due to conflicting column formatting JSON or default styles.

Open Column Settings

Click on the column header of the missing calculated date in your list view, then select 'Column settings' from the dropdown menu.

Format the Column

Click on 'Format this column' to open the formatting pane on the right side of the screen.

Edit Styles

Under the 'Format dates' section, choose 'Edit styles'. Verify and correct the date format.

Check Font Color

Ensure the font color is not set to transparent or a color that matches the background. Save the changes to see if the date appears.

Verification: If the dates immediately populate after changing the style, the issue was related to front-end rendering rather than the formula itself.

Solution 2

Use a Text-Based Formula Workaround

If the date data type is bugged in the list view, converting the calculated result to a text format can force it to display properly.

Solution 3

Test in a New Column and Report the Bug

If formatting and workarounds fail, the issue might be a backend Microsoft Lists bug involving the DATEVALUE function.

Free Microsoft Office alternative

Manage Your Data Seamlessly with WPS Office

If Microsoft Lists or SharePoint bugs are slowing down your productivity, consider tracking your data and complex formulas using WPS Spreadsheet. It provides a free, lightweight, and highly compatible alternative for managing tabular data without frustrating list-view display glitches.

1. Download and Install: Get WPS Office from the official website and install it on your device.
2. Export SharePoint Data: Export your problematic Microsoft List to an Excel file format (.xlsx).
3. Open with WPS Spreadsheet: Open the exported file in WPS Spreadsheet to confidently track, calculate, and format your dates offline or via cloud.

Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your calculated date formulas work flawlessly.Lightweight application with fast installation and zero cloud-sync rendering bugs.Free to use with a familiar, easy-to-navigate interface.Seamlessly handle date calculations, formatting, and data sorting without hidden values.

microsoft office alternative - wps office

Frequently Asked Questions

Why does a SharePoint calculated column show in the form but not in the view?

This usually occurs due to corrupted column formatting, incorrect JSON view formatting applied to the list, or a known rendering bug in modern Microsoft Lists views where calculated date types fail to display.

Does the DATEVALUE function work in Microsoft Lists calculated columns?

While DATEVALUE is natively supported, recent bugs in Microsoft Lists occasionally cause columns relying on this function to return blank values in list views, despite calculating perfectly in the background edit form.

How do I force SharePoint to recalculate a column?

You can force a recalculation by editing the column settings, making a minor invisible change (like adding a space at the end of your formula), saving it, and then removing the space and saving again.

Document & File Issues