Time and Date Formats -

Apply standardized date formats in your sheet date format DateFormat is an option that determines the date formatting of dates date format Select the cells you want to format Press CTRL+1 In the Format Cells box, click the Number tab In the Category list, click Date, and then choose a date

json format Select the cells you want to format Press CTRL+1 In the Format Cells box, click the Number tab In the Category list, click Date, and then choose a date