How to fetch month name from date in excel

00:00we can extract month name from day by

00:03using text function text function takes

00:06two parameters value and format so let's

00:10see how we can get month name from these

00:12dates formula that I will use equal to

00:17text bracket and in first parameter that

00:22is value I will select date then comma

00:27now I want month name so for that second

00:30parameter I will use inverted comma and

00:334 times M inverted comma bracket closed

00:41press Enter we can see that by using

00:45text function we have got the month name

00:47from given date I will drag this formula

00:50down and this is how we can make use of

00:56text function to get month name from

00:59given date we can use text function to

01:02get month name or month in some other

01:05format also let's try one more example I

01:08will use equal to text bracket then I'll

01:14select date comma this time instead of

01:18giving M four times I will give just two