
Google Sheets Basics
How to Change Date Format to UK In Google Sheets (4 Methods)
Learn how to change date format to UK in Google Sheets by adjusting regional settings, using TEXT or QUERY functions, or custom formatting.
Read article
5 articles tagged with “Google Sheets Date Format”

Learn how to change date format to UK in Google Sheets by adjusting regional settings, using TEXT or QUERY functions, or custom formatting.
![[Fixed] Date Format Not Working in Google Sheets](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-date-format-not-working-fcc5ddbe.webp)
Fix date formatting issues in Google Sheets by confirming dates, correcting text issues, removing quotes, and using DATEVALUE and SUBSTITUTE.

Learn how to convert text to date in Google Sheets using DATE, TO_DATE, ARRAYFORMULA, and DATEVALUE functions for quick formatting.

Learn how to convert timestamps to dates in Google Sheets using INT, TO_DATE, TEXT, SPLIT functions, or by formatting cells directly.

Learn how to remove time from date in Google Sheets using formatting, text splitting, rounding, or the DATE function.