How to change date format in google sheet

Let’s take a look at date and time formats applied to the same value – the TDATA function, which takes no arguments and returns the current time and date.

So, in all cells there is one and the same function – TDATA. Both date and time are returned.

Automatically, when entering this function, the “Date and Time” format is used, it can also be enforced.

It is also possible to display only the date or only the time. Although the cell actually contains both.

Pay attention to the number format. 43 159, 78 is February 28, 2018, 18:40. The fact is that for Tables (like Excel, by the way) the date is an integer. This is what allows them to be added and subtracted, compared. If you change the format of any number to “Date”, the cell will contain the date corresponding to this number. One unit is one day. 0 is 12/30/1899, and, for example, 100 is a day 100 days later than 12/30/1899, that is, 04/09/1900.


Sheets also have custom date and time formats. To create them, you need to go to Format -> Numbers -> Other formats -> Other date and time formats


There you will have the opportunity to choose one of the many ready-made formats in the list:


Or create your own. To change the presentation format of one of the elements (day, month, year, hours, minutes, seconds), click on the arrows next to this element and select a view:

To add a new item, click on the small button at the right end of the field:


You can add words and phrases between the elements, symbols – everything is limited only by your imagination. Hope the above article is informative. To get more tutorials like this please visit us on our official web page.

Leave a Comment

Your email address will not be published. Required fields are marked *