Working days between dates
Count the weekdays between the start (B) and end (C) dates in column D.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Working days” in D1
- Working days in D2:D1000
Use it in MacroRoni: open the Starter gallery, search for "Working days between dates", 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