End of the month
Write the last day of the month 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 “Month end” in B1
- Month-end formula in B2:B1000
- Show B2:B1000 as dates
Use it in MacroRoni: open the Starter gallery, search for "End of the month", 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