Convert date into a Month Name using Excel TEXT Function #ytshorts #excel #shortsvideo

You can Extract Month from Date by using Text Function in Excel.
Text Function can be used to get month from date by passing two
parameters. First parameter as Date and Second parameter as mm
or mmmm. For full month names use mmmm. For Month number use mm.

Convert Date into a Month TEXT Formula

Change number in date format | Excel formulas | Text Function
#excel​ #excelformula​ #advance​

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

Convert date into a Month Name using Excel TEXT Function

#exceleducation
#excelformula
#shortsvideo
#excelacademy
#excelfunction
#exceltutorial
#exceltech
#spreadsheetfunctions
#googlesheets
#googlesheetsautomation