Convert Date to Month and Year using the TEXT Function This is because this method does not provide a lot of flexibility compared to the other two methods we will show next. You will be left with only the converted values that have the month and year.Īlthough this is quite an easy and intuitive way to convert dates to month and year, it is a less popular method. Now you can go ahead and delete columns A to C. In this way, you can display the month and year in any format that you like.įinally, if you want to just keep the converted values and want to remove the original dates and any intermediate columns that you created you need to first convert the formula results into constant values.įor this, copy the cells of column D and paste them as values in the same column (Right-click and select Paste Options->Values from the Popup menu). Now all your cells in column D2 have the new format:Īlternatively, if you want to display your month and year as 2/2018 instead, you only need to replace the “-“ in-between with a “/”. Copy this to the rest of the cells in the column by dragging down the fill handle or double-clicking on it. This should display the original date in our required format.Alternatively, you can type: =MONTH(A2) & “-” & YEAR(A2). Click on a blank cell where you want the new date format to be displayed (D2).Let us say you want to display both month and year as “2-2018” for the date “”, and want to follow this pattern for all the dates. Now let’s see how you can combine the results of the two to display both month and year in a nice format. You will see column C populated by the year corresponding to all the dates of column A.
Convert Date to Month and Year using the TEXT Function.Convert Date to Month and Year using the MONTH and YEAR function.