Quarter from a date
Write Q1, Q2, Q3 or Q4 for 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 “Quarter” in B1
- Quarter formula in B2:B1000
Use it in MacroRoni: open the Starter gallery, search for "Quarter 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