Hi, I need a formula to get the month name.

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Hi,

I need a formula to get the month name from date and time for example - ("Aug 25th, 2010 08:48 AM").

When i try =text(A1,"mmmm") it gives the whole date and time together...Is there a way to solve this and get the name of the month only???

Thanks Pedie.

Any suggestion would be great and highly appriciated...;)
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,533
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Hi Pedie
One "m" too many
Code:
=TEXT(A1,"mmm")
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Code:
=TEXT(A1,"mmm")


I have tried this too but won't give the month name only...The result is the date and time.

Oh i think it is because the format is "Sep 28th, 2010 09:05 PM" this way.
Could be funny for you but I have pulled all my thread here in Mrexcel and trying to get the month in 1 col so that I can filter and check month wise...:biggrin:

Now i will need something to get the month from 'Sep 28th, 2010 09:05 PM' format ( this is in general format and even if i change the format to date it doesnt change.....). May be trim/ something....;)

Thanks again Mike
 

Haseeb Avarakkan

Well-known Member
Joined
Sep 28, 2010
Messages
902
Office Version
  1. 365
Platform
  1. Windows
Looks like you have a text entry instead of a date & time format.

Try this,

=LEFT(A1,3)
 

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
But if you have Sept 25th this might work...

=TEXT(LEFT(A1,FIND(",",A1)-3),"mmm")
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Great, did work now. thanks alot!
Todays post shows Tod, and Yesterdays Yes.....

Thanks again:)
 

Forum statistics

Threads
1,136,341
Messages
5,675,204
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top