Month Name from date in number format

[Robert_Conklin]

Good afternoon,

I am in need of a formula that will identify the month name in one column from the month number is another column. To be specific, I need the "MONTH" column to show the abbreviated month name using the number in the "MONTH #" column. Any help would be greatly appreciated.

[TABLE]
[TR]
[TD]Ordered Date[/TD]
[TD]YEAR[/TD]
[TD]MONTH #[/TD]
[TD]MONTH[/TD]
[/TR]
[TR]
[TD][RIGHT]11/28/2022[/RIGHT][/TD]
[TD]2022[/TD]
[TD]11[/TD]
[TD]Nov[/TD]
[/TR]
[TR]
[TD][RIGHT]4/3/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]4[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD][RIGHT]3/28/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD][RIGHT]3/27/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD][RIGHT]3/3/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD][RIGHT]3/24/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Jul[/TD]
[/TR]
[TR]
[TD][RIGHT]1/26/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]1[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD][RIGHT]3/31/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD][RIGHT]1/15/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]1[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD][RIGHT]3/22/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD][RIGHT]3/31/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD][RIGHT]3/16/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD][RIGHT]7/11/2022[/RIGHT][/TD]
[TD]2022[/TD]
[TD]7[/TD]
[TD]Jul[/TD]
[/TR]
[TR]
[TD][RIGHT]3/29/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD][RIGHT]3/16/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[TR]
[TD][RIGHT]2/27/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]2[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD][RIGHT]3/25/2023[/RIGHT][/TD]
[TD]2023[/TD]
[TD]3[/TD]
[TD]Mar[/TD]
[/TR]
[/TABLE]

 

[Sufiyan97]

Do you want something like?

Book5
	A	B	C	D
1	1	Jan	Jan
2	2	Feb	Feb
3	3	Mar	Mar
4	4	April	Apr
5	5	May	May
6	6	June	Jun
7	7	July	Jul
8	8	August	Aug
9	9	Sept	Sep
10	10	Oct	Oct
11	11	Nov	Nov
12	12	Dec	Dec
13
Sheet1

Cell Formulas
Range	Formula
B1:B12	B1	=CHOOSE(A1,"Jan","Feb","Mar","April","May","June","July","August","Sept","Oct","Nov","Dec")
C1:C12	C1	=TEXT(A1*29,"mmm")

 

[Fluff]

As your data is totally unreadable maybe

=TEXT(A2,"mmm")

In future please do not put data inside code tags.

 

[Robert_Conklin]

My apologies, Fluff. Below is my sample data set.

Ordered Date	YEAR	MONTH #	MONTH
11/28/2022​	2022	11	Nov
4/3/2023​	2023	4	Apr
3/28/2023​	2023	3	Apr
3/27/2023​	2023	3	Mar
3/3/2023​	2023	3	Mar
3/24/2023​	2023	3	Jul
1/26/2023​	2023	1	Jan
3/31/2023​	2023	3	Jan
1/15/2023​	2023	1	Jan
3/22/2023​	2023	3	Mar
3/31/2023​	2023	3	Feb
3/16/2023​	2023	3	Feb
7/11/2022​	2022	7	Jul
3/29/2023​	2023	3	Mar
3/16/2023​	2023	3	Mar
2/27/2023​	2023	2	Feb
3/25/2023​	2023	3	Mar
4/7/2023​	2023	4	Apr
4/5/2023​	2023	4	Apr

 

[Robert_Conklin]

I tried your formula, Sufiyan. It worked perfectly. Thank you so much for the help.

 

[Sufiyan97]

You're welcome
Glad we could help.

 

[Fluff]

Why not just use the date rather then the month number

Fluff.xlsm
	A	B	C	D
1	Ordered Date	YEAR	MONTH #	MONTH
2	28/11/2022	2022	11	Nov
3	03/04/2023	2023	4	Apr
4	28/03/2023	2023	3	Mar
5	27/03/2023	2023	3	Mar
6	03/03/2023	2023	3	Mar
7	24/03/2023	2023	3	Mar
8	26/01/2023	2023	1	Jan
9	31/03/2023	2023	3	Mar
10	15/01/2023	2023	1	Jan
11	22/03/2023	2023	3	Mar
12	31/03/2023	2023	3	Mar
13	16/03/2023	2023	3	Mar
14	11/07/2022	2022	7	Jul
15	29/03/2023	2023	3	Mar
16	16/03/2023	2023	3	Mar
17	27/02/2023	2023	2	Feb
18	25/03/2023	2023	3	Mar
19	07/04/2023	2023	4	Apr
20	05/04/2023	2023	4	Apr
Master

Cell Formulas
Range	Formula
D2:D20	D2	=TEXT(A2,"mmm")

 

[Robert_Conklin]

Why not just use the date rather then the month number

Fluff.xlsm
	A	B	C	D
1	Ordered Date	YEAR	MONTH #	MONTH
2	28/11/2022	2022	11	Nov
3	03/04/2023	2023	4	Apr
4	28/03/2023	2023	3	Mar
5	27/03/2023	2023	3	Mar
6	03/03/2023	2023	3	Mar
7	24/03/2023	2023	3	Mar
8	26/01/2023	2023	1	Jan
9	31/03/2023	2023	3	Mar
10	15/01/2023	2023	1	Jan
11	22/03/2023	2023	3	Mar
12	31/03/2023	2023	3	Mar
13	16/03/2023	2023	3	Mar
14	11/07/2022	2022	7	Jul
15	29/03/2023	2023	3	Mar
16	16/03/2023	2023	3	Mar
17	27/02/2023	2023	2	Feb
18	25/03/2023	2023	3	Mar
19	07/04/2023	2023	4	Apr
20	05/04/2023	2023	4	Apr
Master

Cell Formulas
Range	Formula
D2:D20	D2	=TEXT(A2,"mmm")

[/RAN

Cell Formulas
Range	Formula

Thank you for the option, Fluff. The report that I have been tasked to create use the year and the month name. I cannot get the pivot table to pull those values from the full date in number format. So I have to separate them out.

 

[Fluff]

Ok