Let us see the procedure how to get name of the month from today's date using MonthName function 'Procedure to Get Month Name From Date Sub VBA_Get_Month_Name () 'Variable declaration Dim sMonth_Name As String 'Retrieve month Name from date sMonth_Name = MonthName (Month ("")) 'Display month name MsgBox "If Date is "" The Month function takes Date as a parameter and returns a number between 1 and 12, that is the month of the date provided Format Month(strDate) Arguments strDate Mandatory; This formula will get a date with the year and month only from the orignial date in Cells If you only want to extract month from a date, and you can use the following formula = TEXT (B1,"mmm") If you want to convert date to year format only, you can use the following formula =TEXT (B1,"yyyy") Excel Text function
Year In Excel Formula Examples How To Use Year Function
