Practical guide 3 min read
How to count business days between two dates
Count working days with the right weekends, public holidays and days off, and avoid the classic off-by-one mistake.
Move a date forward or backward by years, months, weeks, calendar days or business days.
Your time, clearly
?
Choose your options to begin.
Adding one month to January 31 lands on the last day of February. A business-day offset skips days outside your workweek and your excluded dates. Calendar weeks always add seven days.
No. Adding 1 day to a Monday gives Tuesday, and adding 1 business day to a Friday gives the next working day, usually Monday.
Years and months first, then weeks as 7 calendar days, then the days as calendar or business days. So 1 month and 1 day after January 31, 2026 is March 1: February 28, then one more day.
Choose “Subtract / move backward” as the direction, for example to find the date 30 business days before a closing date.
Calculate date differences, business days, age, date offsets and work hours with custom workweeks, holiday calendars and CSV exports.
A little guidance
Practical guide 3 min read
Count working days with the right weekends, public holidays and days off, and avoid the classic off-by-one mistake.
Cookies on LabAnvil
Analytics and advertising cookies help us see which tools people find useful and keep the site funded. Nothing is stored until you accept. See the privacy page for what gets collected.