Stamp today's date
Write “Updated” and today's date at the top of the sheet.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Updated” in A1
- Write today's date in B1
- Show B1 as a date
Use it in MacroRoni: open the Starter gallery, search for "Stamp today's 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