Year from a date
Write the year of each date in column A into column B, ready for grouping.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Year” in B1
- Year formula in B2:B1000
Use it in MacroRoni: open the Starter gallery, search for "Year 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