To convert a date to the month name with 3 letters (e.g., Aug), please copy the formula and change the cell name.
To convert a date to the month with all letters (e.g., August), please copy the formula and change the cell name.
Alternatively, please follow the steps below to format the date into the month name:
Step 1: Select the date range and click the "Home" tab from the ribbon;
Step 2: Click the right bottom corner in the "Number" group;
Step 3: In the "Format Cell" window, click "Custom" and type "mmm" in the type box to have the month name with 3 letters and type "mmmm" in the box to have the full month names;
Step 4: Click "OK" at the bottom.