How to get month and year from date

[Tyrel Smith]

Could someone please help me.

I have a 2 columns one with a date and I want to put the month of the date in the other, see below

11/01/2020	I want the month and year of the date here ie. Jan 2020
12/02/2020	ie. Feb 2020
13/03/2020	Ie. Mar 2020
14/04/2020	ie. April 2020

Please help.

 

[Peter_SSs]

Welcome to the MrExcel board!

If you are looking for a text result then try this

20 11 21.xlsm
	A	B
1
2	11/01/2020	Jan 2020
3	12/02/2020	Feb 2020
4	13/03/2020	Mar 2020
5	14/04/2020	Apr 2020
Month Year

Cell Formulas
Range	Formula
B2:B5	B2	=TEXT(A2,"mmm yyyy")

 

[Tyrel Smith]

Welcome to the MrExcel board!

If you are looking for a text result then try this

20 11 21.xlsm
	A	B
1
2	11/01/2020	Jan 2020
3	12/02/2020	Feb 2020
4	13/03/2020	Mar 2020
5	14/04/2020	Apr 2020
Month Year

Cell Formulas
Range	Formula
B2:B5	B2	=TEXT(A2,"mmm yyyy")

That's the problem I'm having I tried that but because I have other things leading off of this column it cant be text so I want to sort of copy that what is in the first column and format it to show only the month and year

 

[Peter_SSs]

In that case just use this formula

20 11 21.xlsm
	A	B
1
2	11/01/2020	Jan 2020
3	12/02/2020	Feb 2020
4	13/03/2020	Mar 2020
5	14/04/2020	Apr 2020
Month Year

Cell Formulas
Range	Formula
B2:B5	B2	=A2

.. and format that result column with a custom format of mmm yyyy like this

 

[Tyrel Smith]

In that case just use this formula

20 11 21.xlsm
	A	B
1
2	11/01/2020	Jan 2020
3	12/02/2020	Feb 2020
4	13/03/2020	Mar 2020
5	14/04/2020	Apr 2020
Month Year

Cell Formulas
Range	Formula
B2:B5	B2	=A2

.. and format that result column with a custom format of mmm yyyy like this

View attachment 26498

I tried that but when I do that it stays the same it doesn't want to format.

 

[Peter_SSs]

I tried that but when I do that it stays the same it doesn't want to format.

In that case most likely your original 'dates' are text. Follow the same process as above but change the cell formula to

=A2+0