How To Get Month and Year From Date EXCEL Aug-2019

#MonthandYear #LearnwithPassion #ExcelTips

This video will helps you to extract month and year form date like, Aug-2019.Date format should be like "dd/mm/yyyy".

=TEXT(A1,"mmmm-yyyy") As August-2019
=TEXT(A1,"mmm")&"-"&TEXT(A1,"yyyy") As Aug-2019
=TEXT(A1,"mmm-yyyy") As Aug-2019

[abdou]

I spent hours about this before founding that it 's only a 49 seconds video. So thank you

[tahirmalek]

Thank you very much for this.

You can save my time .

[friendsofcrls]

Thank you! That's a very helpful video.

[krishankantsharma]

Thank you so much for this knowledgeable video.. Please post video for excel learning.

[gamenwatch]

thank you somuch, just what i am looking for

[amitkumar-pfmg]

If I want month in numerical then how can I put the formula

[mrtochkalt]

how did you do it can you share with me, thank you

[RichaSingh-lgss]

i did the same thing for year only but is shows same date means date/month/ year

[ananthmuthiah]

This stores the date in text format. how to convert to date format?

[bdsanwar]

In PIVOT, how to keep months to Ascending or Descending order ...

[Sushilsharma-yctx]

Agr year serialei na ho fir kaise serailwise krein