fetch

Formula to Extract Month from Date in Excel 2013



Sharing buttons:

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