Formula for Date Name

[Iccreamann21]

Hello, Good Morning, Happy 2024,

Quick questions, the data I am exporting has the column "Closed Date" and what I'm looking to do is extract just the name of the month.

Closed Date	Month Name
12.21.2023	December

Currently, I am doing this way and it works, but Im trying to eliminate having to add the cheater cell and the AA:AB table.

Closed Date	Cheater	Month Name
12.21.2023	=left(A2,2)	=vlookup(B2,AA:AB,2,0) <- then create a table in column in AA:AB

Any help will be appreciated. Thank you

 

[Coyotex3]

Maybe, assuming your date is in cell A2. If the date is in cell A1, please change the cell reference.

=TEXT(A2,"mmmm")

 

[Iccreamann21]

Maybe, assuming your date is in cell A2. If the date is in cell A1, please change the cell reference.

=TEXT(A2,"mmmm")

When I try using that formula it just replicates whats in A2

Closed Date	Month Name
12.21.2023	12.21.2023

 

[awoohaw]

just format the cell you want the date's month in as mmmm:

Book1
	A	B	C
1	Closed Date	keep date value	as text
2	12.21.2023	December	December
Sheet3

Cell Formulas
Range	Formula
B2	B2	=A2
C2	C2	=TEXT(A2,"mmmm")

 

[Coyotex3]

Hmmm oddly enough I'm unable to replicate the same result.

 

[awoohaw]

Hmmm oddly enough I'm unable to replicate the same result.

View attachment 104663

A picture doesn't help debug.
and you've cchanged the formatting of cell A2. Is it a date value or text?

 

[Coyotex3]

At work, I can't use XL2BB.

I did not. What I have is 12/21/2023 Date format. Cell A2 is in general format, still showing "December" as OP wanted. Cell D1 just includes

=FORMULATEXT(B1)

Edit. I see my mistake. OP is using 12.21.2023 as opposed to 12/21/2023. My bad!

 

[Iccreamann21]

Closed Date	Column4
	January
12.21.2023	12.21.2023
12.21.2023	12.21.2023
	January
	January
12.20.2023	12.20.2023
12.19.2023	12.19.2023
12.19.2023	12.19.2023
12.19.2023	12.19.2023

First time trying out XL2bb.. Hopefully this helps

 

[Fluff]

How about

=IF(A2="","",TEXT(DATE(2024,LEFT(A2,2),1),"mmmm"))

 

[Coyotex3]

Another option which might work for OP

=TEXT(SUBSTITUTE(A1,".","/"),"mmmm")