How to Create a Custom Date in Google sheets

Published June 17, 2022

If you do not like the dates provided by Google Sheets, you can improvise them yourself. In this article, we describe how you can access Custom Date formats.

How to Create a Custom date in Google sheets

Step 1:  First of all, on your Google sheets menu, click on “Format”

Create a Custom Date in Google sheets

 

Step 2: On the “Format” submenu, hover over “Numbers” and click on “custom date and time”

Create a Custom Date in Google sheets2

 

Step 3:   The "Custom date and time formats" window will appear on your screen

Create a Custom Date in Google sheets3

 

Step 4:  Select the arrow at the right of the field and then select the unit you wish to purchase.

Create a Custom Date in Google sheets4

 

Step 5: You can adjust the units with the double arrows by clicking on the units so that they display the value precisely

Create a Custom Date in Google sheets5

 

Step 6: Click “Save”

Create a Custom Date in Google sheets6

Conclusion

If the preset date formulae are unsatisfactory, you may insert your own. Just open the date format window with the predefined formatting choices, and follow the set of steps outlined in this article

 

Keywords: Google Docs, Google Sheet, Create a Custom Date in Google sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

57 Views