Here's what format I've created and how my dates look now:
You are free to separate the units with various characters including commas, slashes, and dashes. This way, you can edit all values, insert additional and delete obsolete ones. Click them and you'll be able to adjust the exact way to display the value.
How to change date format in Google Sheets.I also describe a couple of ways of how to convert your dates to numbers and text if necessary. There are even a couple of handy functions for the task. Some date formats are offered to you by spreadsheets while others should be created from scratch. In this tutorial, you will find out how Google stores dates and how you can format them for your better convenience.
And like many other concepts of spreadsheets, they require a bit of learning. Dates are an inevitable part of Google Sheets.