If you want to convert the date to a month name, you can use the TEXT function with a specified format code like "mmm"in excel You can try to run the following TEXT formula =TEXT(B1,"mmm") Assuming that you want to get the month name from the date value 12/1/18 in Cell B1, then you can enter the above TEXT function into Cell C1A1 cell is having the date in m/d/yyyy format Here is the formulaThis simple twoline macro dynamically returns the month name for whatever the current date is Just put this formula in a cell =MonthName() Remember—since you've just added a macro to your workbook, you'll be asked whenever you open your workbook if you want to enable macros If you don't want to see this question all the time, you should use one of the formulaic
How To Get Month Name From Date In Excel 4 Easy Ways Trump Excel