3 Easy Ways to Get Month Name from Date in Excel

In this video, I will show you how to get the month name from a date in Excel.

There are multiple ways to get Month names from Dates in Excel and I cover the following methods in this video:
-- Using Custom Number Formatting (the best way)
-- Using TEXT function
-- Using Power Query

----------------------------------------------------------------------------------------------------------------------

00:00 Intro
00:18 Get Month Name using Custom Number Formatting
01:59 Get Month Name using Text Formula
04:15 Get Month Name using Power Query

----------------------------------------------------------------------------------------------------------------------

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.




Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[RahulGupta-mmlf]

First of all thanks for explaining Excel so nicely that even a novice user can fascinated to extraordinary features of MS Excel which is quint essential in professional life as well as in personal life. The way you use interactive learning methodology is absolutely awesome and incomparable. You are not only imparting Teaching but also providing extended support to all strata of society.

[sowmyasankar]

Your teaching methodology is excellent

[madhanmannathan]

first of all many thanks for your video; just today only i found this; becoz i came across this situation today; good job and keep positng such kind of vidoes

[wayneedmondson]

Nice one Sumit! Great tips for extracting the month name from a date. Thanks for sharing :)) Thumbs up!!

[R_K_ENTERTAINMENT]

I like the way ur resolve 1 problem from different possibility specially power query

[aleong]

Every video has been excellent. The information is very clearly presented.

[billderby]

As always, an easy to understand, useful tip

[werkwerks]

Thank you thank you thank you thank you thank you!

[prateekgupta]

Very nice knowledge sir. Keep teaching🙂🙂🙂

[fayazmuhammad]

Thank you sir please start power bi or tableau series

[VinayKumar-ijeu]

Hi Sumit, Great session, could you please update a complete session on Power BI?

[neerajkumar-jtve]

Dear sir, Is any kind of formula available which the automatically row insert in right down the above the row .when we use multiple vlookup to insert the data please sir revert

[mohamedadjal]

hi, Professor sumit bansal, I have a question: If we have numbers in different formats, for example: kg, liters, meters ... When we do research (we use search functions) in the cells that contain these numbers, can we get numbers with their different formats? Thank you . 😃👍

[salvatorett]

Hi I need a formula that notifies me 7 days before the birthday. Can you help me. Thank you.

[preetichoudhary]

in a column if there is date, month year and time and i need date only no need of month and year. how can i get that ?the same formula would be implement ?

[utkarshkathuria]

Hi, Can you help me how to extract month names if I have start and end date and I want to write month names in between those dates?

[virendrahardiya]

Hallo Sumit ji,
Please advise, how to make file name using the cell data, example: If cell "H2" mentioned "inv-2248"
The same I need save as Excel file name "inv-2248".

[farisshah]

Hello, I have a problem with I receive multiple names of places which is spelled wrong. What can I do to make my task easier? appreciate your help

[karthigailakshmig]

How can I copy an equation from word into a cell in Excel as an equation in same format