SharePoint Document Issues

How to Change SharePoint Link Expiration Date Format to DD/MM/YYYY

Maira Mehtab Sep 20, 2026 869 views

Question details

The user needs to change the expiration date format for shared SharePoint links from MM/DD/YYYY to DD/MM/YYYY.

Product: SharePoint Online
Device & OS: not provided
Scenario: Generating a shareable document link with a specific expiration date in SharePoint Online.
Observed behavior: SharePoint displays the link expiration date in the US MM/DD/YYYY format, despite the site requiring the UK DD/MM/YYYY format.

Before you start

Ensure you have Site Owner or Administrator permissions to access and modify the regional settings for your SharePoint Online site.

Solution 1Recommended

Configure SharePoint Site Regional Settings

Setting the site's regional locale to the United Kingdom will default the date format to DD/MM/YYYY for the site's interfaces, including the sharing dialog.

SharePoint date formats are primarily dictated by the site's regional settings. If these settings default to a US locale, expiration dates will appear in the MM/DD/YYYY format.

Access Site Settings

Log in to your SharePoint Online site. Click the gear icon (Settings) in the top right corner, then select 'Site information' and click on 'View all site settings'.

Open Regional Settings

In the Site Settings page, locate the 'Site Administration' section and click on 'Regional settings'.

Change the Locale

Find the 'Locale' dropdown menu and change the selection to 'English (United Kingdom)' or another locale that natively uses the DD/MM/YYYY format.

Save Changes

Scroll to the bottom of the page and click 'OK' to apply the changes. Reopen the sharing dialog to confirm the date format has updated.

Tip: Changes to site regional settings may take a few moments to propagate across all site interfaces. Refresh the page if the format does not update immediately.

Solution 2

Verify Microsoft Account Language and Region Preferences

Update your personal Microsoft 365 profile settings, as individual account preferences can override SharePoint site-wide regional settings.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage and Share Documents?

If troubleshooting Microsoft SharePoint settings becomes too complex, consider switching to WPS Office. It provides a lightweight, intuitive, and highly compatible workspace for creating and securely sharing your documents.

1. Download WPS Office: Install WPS Office for free from the official website and open your document.
2. Click Share: Click the 'Share' button in the upper right corner of the document interface.
3. Set Expiration and Send: Configure your link permissions and straightforward expiration dates, then copy the link to share with colleagues.

Fully compatible with Microsoft Word, Excel, and PowerPoint document formats.Easily share documents via secure cloud links with built-in expiration dates and access permissions.Free, lightweight application with a familiar and user-friendly interface.Seamless file migration from Microsoft Office without any steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SharePoint link expiration date still in MM/DD/YYYY after changing site settings?

SharePoint prioritizes personal Microsoft 365 account settings over site-wide regional settings. If your personal account is set to US English, the date will remain in MM/DD/YYYY format. You must update your personal profile's language and region preferences to resolve this.

Does changing the regional locale affect other SharePoint site settings?

Yes, changing the regional locale will affect how dates, times, numbers, and currencies are displayed across the entire SharePoint site for users who rely on the site's default settings.

Can I set a specific date format just for the sharing link dialog?

No, SharePoint does not allow you to isolate the date format exclusively for the sharing dialog. It relies entirely on either the global site regional settings or the individual user's Microsoft 365 profile language settings.

Document & File Issues