Day of the week
Write the weekday (Monday, Tuesday…) 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 “Day” in B1
- Weekday formula in B2:B1000
Use it in MacroRoni: open the Starter gallery, search for "Day of the week", 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