Others

Fix Microsoft Lists Dates Changing to the Previous Day

Bushra Parveen Oct 10, 2026 870 views

Question details

Users report that dates imported from Excel into Microsoft Lists shift back to the previous day when the 'Include time' option is disabled, despite appearing correctly in the preview.

How to Fix Microsoft Lists Dates Changing to the Previous Day

Product: Microsoft Lists
Device & OS: not provided
Scenario: Importing an Excel spreadsheet into Microsoft Lists without including time values.
Observed behavior: The imported dates shift to the previous day in the final list, suggesting a backend date-conversion or timezone bug.

Before you start

Verify that your original Excel file contains the correct dates and that your local computer's timezone matches your Microsoft 365 account settings. This ensures the date shift isn't caused by a simple local configuration error.

Solution 1Recommended

Submit a Support Ticket for Backend Investigation

Since this issue is reproducible across different tenants, it is a confirmed backend bug that requires Microsoft development team intervention.

This behavior originates from a server-side conversion error when stripping time values from the date string. To resolve this permanently for your tenant, a formal support request must be submitted so that Microsoft engineers can analyze the diagnostic logs.

Sign in to Microsoft 365 Admin Center

Go to the Microsoft 365 admin portal and log in using an account with administrator privileges.

Open the Support pane

Navigate to the bottom right of the screen or the left-hand menu and click on 'Help & Support'.

Create a new service request

Describe the date-shifting issue thoroughly. Mention that it happens when 'Include time' is disabled and offer to provide HAR logs for their development team to investigate.

Submit a Support Ticket for Backend Investigation

Admin Access Required: If you do not have administrator permissions, you must ask your organization's IT department or Microsoft 365 admin to submit the ticket on your behalf.

Solution 2

Keep 'Include time' Enabled as a Workaround

Temporarily bypass the backend date-shifting bug by retaining the time values during the import process.

Free Microsoft Office alternative

Experience Accurate Spreadsheet Management with WPS Office

If backend bugs and date-shifting issues in other platforms disrupt your workflow, try WPS Office. It is a free, lightweight, and user-friendly suite that offers excellent compatibility with Microsoft Office formats, ensuring your data and dates are handled precisely.

1. Download WPS Office: Visit the official WPS website to download and install the free suite on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files directly with full formatting retained.
3. Manage Data Accurately: Edit, format, and organize your date values confidently without worrying about unexpected backend conversions.

Fully compatible with Microsoft Excel (.xlsx) formatsAccurate date and time formatting without unexpected shiftsLightweight installation with a familiar, easy-to-use interface

microsoft office alternative - wps office

Frequently Asked Questions

Why do imported dates change by one day in Microsoft Lists?

This usually happens due to timezone conversion discrepancies or a backend bug that is triggered when the 'Include time' option is disabled during the Excel data import process.

How do I generate HAR logs for Microsoft support?

You can generate HAR logs by opening your browser's Developer Tools (usually by pressing F12), navigating to the Network tab, performing the import action that causes the error, and exporting the recorded network activity.

Can I fix the date conversion issue without administrator privileges?

While you cannot submit a formal backend fix ticket to Microsoft without admin rights, you can bypass the issue locally by keeping the 'Include time' option enabled during import.

Office Quick Solutions