Business Days Calculator

Calculate the date that is a given number of business days from a start date. Excludes weekends automatically.

This calculator walks the calendar one real day at a time from your start date, checking each day's weekday before deciding whether it counts (lines 19-25) -- it doesn't use a shortcut formula like dividing by five-sevenths, so it correctly steps over however many Saturdays and Sundays actually fall in the span, whatever that span turns out to be. A positive Business Days value walks forward; a negative one walks backward from the start date instead, using the same weekday check in reverse (line 16). Once the walk finishes, End Date reports the specific weekday and calendar date it landed on, built from the actual date it stopped at rather than an estimate (line 35). Calendar Days is the full span between start and end date, counting weekends and all; Weekend Days Skipped is just that span minus however many business days you asked for, since every day in the span is either a business day or a weekend day (line 29). Business Days has a real, direct effect on both Calendar Days and Total Weeks, since a larger magnitude of Business Days -- further from zero in either direction -- always means walking further to satisfy the request: a bigger magnitude always produces a longer or equal calendar span, never a shorter one. That growth tracks magnitude, not the raw signed value, since Business Days can be negative (walking backward) as well as positive -- going from -10 to -5 is a smaller magnitude even though -5 is the larger number, and it produces a shorter walk and a closer End Date, not a further one. The calculator does not treat any date as a holiday; it only excludes Saturdays and Sundays, so a stretch of business days that includes a public holiday will still count that holiday as a working day.