Excel - How To Get The Month Name From Date In Excel - Episode 1414
Microsoft Excel Tutorial How To Get The Month Name From Date In Excel
Welcome back to the MrExcel podcast. In this episode, we will be discussing how to extract the month name from a numeric date in Excel. This question was sent in by Nick, who was struggling to find a formula that would give him the month name from a date in his spreadsheet. But fear not, there is a much simpler solution that we will be sharing with you today.
First, let's take a look at the date in question, which is August 25th, 2011. We can see that the month name is already spelled out, but we want to find a way to extract it using a formula. The trick here is to use the TEXT function, which allows us to display a value in a custom number format. By using the format "4 m's" (mmmm), we can convert the numeric date to the month name. So, the formula would be =TEXT(A1,"mmmm"), where A1 is the cell containing the date.
But wait, there's more! The TEXT function also allows us to display the weekday name, using the format "4 d's" (dddd). This means that we can also use this formula to find out what day of the week a certain date falls on. For example, =TEXT(A1,"dddd") would give us "Thursday" for August 25th, 2011. And if you want to see the abbreviated month or weekday name, you can use "3 m's" (mmm) or "3 d's" (ddd) respectively.
But that's not all, there are many other custom date formats that you can use with the TEXT function. For example, using "2 d's" (dd) will add a leading zero to single-digit dates, and using "y" or "yy" will give you the two-digit year. You can also use "yyyy" for the four-digit year. And if you want to see all the available date formats, simply go to Format Cells (Ctrl+1) and select the "Custom" category.
So there you have it, a simple and efficient way to extract the month name or weekday from a numeric date in Excel. We hope you found this tip useful and we'll see you next time for another netcast from MrExcel. Don't forget to subscribe to our channel and leave a comment if you have any questions or suggestions for future episodes. Thanks for watching!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(00:00) Get Month Name from Date in Excel
(00:28) VLOOKUP would be complicated
(00:45) Custom Date Format MMMM
(00:57) Use =TEXT function with MMMM as format
(01:19) Review of all date formats
(01:40) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
how to get the month name from date in excel
how to convert dates in excel to the month name
how to pull month name from date in excel
how to turn date in month name excel
how to get the name of the month in excel
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Today, Nick asks how to get the word 'August' in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function.
Watch video Excel - How To Get The Month Name From Date In Excel - Episode 1414 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 25 August 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,783 once and liked it 13 people.