how to extract month from date
Using MONTH and EOMONTH functions in Excel - formula examples 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(A2, mmm) - returns an abbreviated month name, as Jan - Dec. =TEXT(A2,mmmm) - returns a full month name, as January - December.