fetch
## Formula to Extract Month from Date in Excel 2013

we can extract month name from day by

using text function text function takes

two parameters value and format so let's

see how we can get month name from these

dates formula that I will use equal to

text bracket and in first parameter that

is value I will select date then comma

now I want month name so for that second

parameter I will use inverted comma and

4 times M inverted comma bracket closed

press Enter we can see that by using

text function we have got the month name

from given date I will drag this formula

down and this is how we can make use of

text function to get month name from

given date we can use text function to

get month name or month in some other

format also let's try one more example I

will use equal to text bracket then I'll

select date comma this time instead of

giving M four times I will give just two

times inverted comma now we can see that

by passing second parameter just two

times M we are getting month number and

I will drag this formula down so this is

how text function can be used to get

month names or month from given date

thank you

you

how to get month name from date in excel

how to get month name from date in excel formula

how to get month name from date in excel vba

how to get previous month name from date in excel

how to get month name and year from date in excel

how to extract month name and year from date in excel

how to get month name out of date in excel

extract month name from date in excel 2013

fetch date from datetime in excel