Free tool · no sign-up

Business-days calculator: WORKDAY and NETWORKDAYS, worked out instantly.

Count the working days between two dates, or add a number of working days to a start date, with weekends and your own holidays left out. It runs right here in your browser, and hands you the exact Wisegrid formula to reproduce it in a sheet.

Mode:
AnswerNETWORKDAYS
22working days

Between Monday, June 1, 2026 and Tuesday, June 30, 2026, inclusive of both dates.

  • 30 calendar days in the range, minus 8 weekend days, leaves 22 working days.
The same answer as a Wisegrid formula:
=NETWORKDAY(DATE(2026, 6, 1), DATE(2026, 6, 30))
Wisegrid ships this as NETWORKDAY (the same working-day count the NETWORKDAYS name carries in Excel and Smartsheet), and WORKDAY, both with the optional holidays argument. Paste this into a cell and it runs.
Run this live in a Wisegrid sheetSame price you already pay, with more of everything.

Why this mattersWisegrid speaks your date formulas natively

The functions come with you

WORKDAY, NETWORKDAY, and NETDAYS all ship in the Wisegrid formula engine, each with the optional holidays argument you already use. NETWORKDAY is the working-day count you know as NETWORKDAYS in Excel and Smartsheet.

So =NETWORKDAY([Start]@row, [End]@row) and =WORKDAY([Start]@row, 5) run in a Wisegrid sheet unchanged. Nothing to rewrite.

One calendar, everywhere

The working-day math your formulas use is the same engine that drives Gantt bar durations and dependency scheduling in Wisegrid.

A formula and a timeline never disagree about how long five working days is, because they read the same calendar and the same holidays.

More date power than a helper row

Beyond WORKDAY and NETWORKDAY, Wisegrid ships DATEADD, EOMONTH, EDATE, ISOWEEKNUM, WEEKDAY, GETMONTHNAME, and more.

Add days, weeks, months, or quarters directly, with end-of-month rollover, instead of building helper columns to fake it.

Bring your whole schedule over

This tool works out one date range. The importer brings your whole Smartsheet workspace across (sheets, formulas, and attachments), and your WORKDAY and NETWORKDAY working-day formulas keep working on the other side. Same price you already pay.

Import from Smartsheet
Frequently asked
How do I count the number of working days between two dates?
Use NETWORKDAYS mode above: enter a start date and an end date. The tool counts every calendar day in that range (both ends included) that is not a Saturday, a Sunday, or a holiday you listed. NETWORKDAYS from a Monday to the following Friday is 5, and a single day that is a working day counts as 1.
What is the difference between WORKDAY and NETWORKDAYS?
NETWORKDAYS takes two dates and returns a count of working days between them. WORKDAY takes one date and a number of working days, and returns the date you land on after moving that many working days forward (or backward, if the number is negative). One gives you a duration, the other gives you a deadline.
Does NETWORKDAYS include the start and end date?
Yes. NETWORKDAYS is inclusive of both endpoints, which matches Excel and Smartsheet. If your start and end are the same working day, the answer is 1. This is why a full Monday-to-Friday week returns 5 rather than 4.
Does WORKDAY count the start date?
No. WORKDAY does not count the start date itself. WORKDAY of a Monday plus 1 working day returns Tuesday, and plus 5 working days returns the following Monday (the intervening weekend is skipped). Passing 0 returns the start date unchanged.
How do I exclude holidays?
Paste your holiday dates into the holidays box, one per line or separated by commas, in YYYY-MM-DD form. Any holiday that falls on a weekday inside your range is removed from the working-day count. Weekends are always excluded automatically. If a line cannot be read as a date, the tool tells you which one rather than silently ignoring it.
Are weekends always Saturday and Sunday?
In this free tool, yes: it treats Saturday and Sunday as non-working days, which is the default for WORKDAY and NETWORKDAYS. If your team runs a different work week, Wisegrid lets you set the working days per workspace, and the Gantt and schedule views use that same calendar. WORKDAY.INTL-style custom weekends are on the roadmap for this tool.
Does Wisegrid support the WORKDAY and NETWORKDAYS formulas?
Yes. WORKDAY, NETWORKDAY, and NETDAYS all ship in the Wisegrid formula engine, each with an optional holidays argument. NETWORKDAY is the working-day count you know as NETWORKDAYS in Excel and Smartsheet, so the math is the same. They sit alongside date functions like DATEADD, EOMONTH, EDATE, ISOWEEKNUM, and WEEKDAY. The same working-day calendar also drives Gantt durations and dependency scheduling, so a formula and a timeline never disagree.
Is this business-days calculator free, and does my data leave my browser?
It is completely free with no sign-up and no email gate. Every date calculation happens in this page in your browser. Your dates and holiday list are never sent to a server. When you want the same math live in your sheets, the WORKDAY and NETWORKDAY functions are built into Wisegrid.
How is this different from a plain days-between-dates calculator?
A plain calculator counts every calendar day, including weekends. This one counts only working days, so it answers the question project managers actually ask: how many business days is this, or what date is N business days out. It is the same logic Smartsheet users lean on NETWORKDAYS for when planning schedules.

Your date formulas already speak Wisegrid.

Bring your Smartsheet workspaces over and pick up exactly where you left off: same grid, same formulas, same schedules. Nothing new to learn Monday morning, and more of everything at the price you already pay.

Start free trialImport from Smartsheet →

Want the full picture? See how Wisegrid compares to Smartsheet → Putting working-day math into a staffing plan? Start from the free capacity planning template.