Days overdue
Show how many days each due date in column C is late (0 if not late), in column D.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Days late” in D1
- Days late in D2:D1000
- Show D2:D1000 as whole numbers
Use it in MacroRoni: open the Starter gallery, search for "Days overdue", 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 & timeMonth name from a dateWrite the month (January, February…) of each date in column A into column B.Changes data · backup on