Month name from a date
Write the month (January, February…) of each date in column A into column B.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Month” in B1
- Month formula in B2:B1000
Use it in MacroRoni: open the Starter gallery, search for "Month name from a date", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More dates & time macros
Dates & timeAge from date of birthWork out each person's age in years from the birth dates in column B, in column C.Changes data · backup onDates & timeDays until dueCount the days from today until each due date in column C, in column D.Changes data · backup onDates & timeDays overdueShow how many days each due date in column C is late (0 if not late), in column D.Changes data · backup on