Formatting date in excel:
Select the data in the date column
Tip 💡To quickly select all the data, highlight the first cell below the heading then press control, shift, and down arrow keys at the same time
Right click anywhere in the selected cells
From the pop up menu, left click Format Cells...
Select Custom format and enter either:
yyyy-mm-dd or yyyy-mm-dd hh:mm
Click Ok to apply
Once this format is added, it will be selectable in the future
Excel sorts alphabetically, so this will appear near the bottom
Formatting date in google sheets:
Select the data in the date column
Tip 💡To quickly select all the data, highlight the first cell below the heading then press control, shift, and down arrow keys at the same time
Click on the "123▼ (More formats) button on the toolbar
Select Custom data and time and enter the following:
Click on the down arrow and select one of the following options:
'Year'-'Month'-'Day'
Make sure to copy below if you do not want to include time
'Year-'Month'-'Day' Hour:Minute
Make sure to copy below if you would like to include time
