Sort list of data by month name with Sort function To sort the data by month name from Jan to Dec, you should do as this 1 Select the data range that you want to sort by month name, and click Data > Sort, in the Sort dialog box, do the following operations (1) Under the Column section, please select the column name that you want to sort based on; Excel names make formulas easier to reuse Excel names make it a lot easier to copy a formula to another sheet or port a formula into a different workbook All you have to do is create the same names in the destination workbook, copy/paste the formula as is, and you will get it working immediately Tip To prevent Excel form creating new names on the fly, copy the formulaTo get the month name (ie January, February, March, etc) from a date as text, you can use the TEXT function with a custom number format In the example shown, the formula in cell C5, copied down, is = TEXT( B4,"mmmm") As the formula is copied down, the TEXT function extracts a month name from each date in column B
Excel Get The Day Or Month Name From A Date Projectwoman Com