WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Set the date format cells

Uploaded time: August 27, 2021 Difficulty Beginner

Set the date format cells

Set the date format cells

In practical work, we often need to enter the date in the spreadsheet. There are many types of date formats, so how do we set the date formats as we need?

It should be noted that 2020-7-1 and 2020/7/1 these two date formats are recognized by the table, while 2020.7.1 and 20200701 these two formats are not recognized by the table under the date formats.

We set the date format for the cell with the content 2020.7.1. After setting, we can find that the cell content has not changed.We set the format to 2020-7-1, which is recognized by the table. Then, we can see that the date format has changed.


Take this table as an example. Select the table area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. In the Regional settingsdrop-down list, we can select our national language first.

There are many date formats in Type. We can chooseWednesdayas the date format,its abbreviated format,or the date format of year, month, day and week.  

After selecting a date format as needed, click OK.


Did you get it?

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.