WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to convert dates to month, year and day in excel?

February 13, 2023
14.2K Views

There may be times while working with date-specific data that you need to identify the weekday, month, or year that corresponds to a certain date. For example, you might be interested in learning the day of the week instead than just the date or you want to convert date to month.

Excel automatically detects the format and changes any date you enter in cell into a date cell. Excel is thus aware of which parts of the date you supplied correspond to the month, the year, and the day.

This has a lot of potential benefits. One special advantage of this ability of excel is that it enables you to extract the desired parts of the date. In this article, we will look at three distinct Excel date conversion methods.

Convert date to year in excel

This method use the YEAR function to convert date to year in excel. Here is the step by step tutorial on how you can do it.

  1. Write your sample dates in a column.

  1. Type the formula: =YEAR(A2), where A2 represent number of cell.

  1. Press the return key.

  2. This should display the year.

  1. Follow the above method with all the dates, just changing the name of corresponding cell in the formula or use the Fill Handle that will auto fill the lower cells

Converting date to month in excel

This method use the MONTH function to convert date to month in excel. Here is the step by step tutorial on how you can convert date to month in excel.

  1. Write your sample dates in a column.

  2. Type the formula: =MONTH(A2), where A2 represent number of cell.

  1. Press the return key.

  2. This should convert the date to month

  1. Follow the above method with all the dates, just changing the name of corresponding cell in the formula or use the Fill Handle that will auto fill the lower cells

Converting date to day in excel

We can convert date to day with TEXT function. Here is the stepwise tutorial.

  1. Write sample dates in a column.

  1. Click on the cell where you want the day to be displayed.

  1. Type the formula: =TEXT(A2,”ddd”), where A2 represent the cell number. You can also use “dddd” for displaying full name of day.

  1. Press the return key

  2. it should display the name of the day.

  1. Now you can type the name of the cells separately in function or use the Fill handle to auto fill the rest of the cells.

The above tutorials are usable in WPS 2016/2019 versions. WPS can be used across various platforms such as windows, mac, iPhone, etc. So, you can use these tutorials on any device without being online.

Did you learn about how to covert date to month, year and day in excel. You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience. 

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