MacroRoni

Starter macros › Dates & time

Days until due

Count the days from today until each due date in column C, in column D.

Changes data. A backup copy and an undo point are turned on.

What it does, step by step

  1. Write “Days left” in D1
  2. Days left in D2:D1000
  3. Show D2:D1000 as whole numbers
  4. Highlight overdue (below 0)

Use it in MacroRoni: open the Starter gallery, search for "Days until due", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

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 overdueShow how many days each due date in column C is late (0 if not late), 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