How to get month and year from date in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-get-month-and-year-from-date-in-Excel.png)
Excel offers a very interesting way to get month and year from a date. We can cater to this problem statement by using the “=MONTH”, and “=YEAR” formulae. We can perform the below mentioned way to get month and year from a date in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a date
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-get-month-and-year-from-date-in-Excel.png)
– Open the desired Excel workbook containing a date
Step 2 – Writing the formula
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-get-month-and-year-from-date-in-Excel.png)
– Now on an empty cell type “=CONCATENATE(MONTH(“, and then give the reference of the cell containing the date then type “),”/”,YEAR(“, then again give reference of the cell containing the date, then hit Enter, as shown in the image above
Step 3 – Month and year obtained
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-get-month-and-year-from-date-in-Excel.png)
– We can see that the month and year have been obtained from the date