Google Sheets Basics: Date Formatting
$2
$2
https://schema.org/InStock
usd
Once you know how dates are formatted in Google Sheets, it gives you plenty of flexibility.
You can change the format of dates into all kinds of formats:
Date Default format: 29 Feb 2024
YYYYMMDD 20240229
ddd mmm dd, yyyy Thu Feb 29, 2024
mm/dd/yyyy 02/29/2024
ddd Thu
dddd Thursday
HH:MM 00:00
ddd mmm dd, yyyy HH:MM AM/PM Thu Feb 29, 2024 12:00 AM
Learn different date formats
Reduce typing or copying and pasting
Make dates easy to read
Make dates easy for sort and calculations
Size
109 MB
Duration
11 minutes
Resolution
1502 x 1080 px
Add to wishlist