Excel has MONTH function that retrieves retrieves month from a date in numeric form How to extract month name from date in Excel In case you want to get a month name rather than a number, you use the TEXT function again, but with a different date code =TEXT (, "mmm") returns an abbreviated month name, as Jan Dec =TEXT (,"mmmm") returns a full month name, asLearn how to get the name of the month (ie January, February, etc) from a date value like 1/1/ in Microsoft ExcelTake my FREE Microsoft Excel Level 1 Convert Month Names to Dates We can exploit this use of the MONTH function to create a date serial number (shown in column C below) You can then format them as a date (shown in column D below), using Format Cells Note The formula in column C converts the month name in column B to the first day of each month in the current year
How To Get Month From Date In Excel
