> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# BusinessDays

> Use the Sigma BusinessDays function to count the weekdays between two dates, excluding Saturdays and Sundays.

The **BusinessDays** function calculates the number of weekdays between two dates, counting both the start and end dates and excluding Saturdays and Sundays.

**BusinessDays** is a [date function](/docs/date-functions).

## Syntax

```
BusinessDays(start, end)
```

Function arguments:

|           |                                                                                                                                                      |
| :-------- | :--------------------------------------------------------------------------------------------------------------------------------------------------- |
| **start** | (required) The starting date or column of dates. If the column isn't in the appropriate format, use the [Date](/docs/date) function on the argument. |
| **end**   | (required) The ending date or column of dates. If the column isn't in the appropriate format, use the [Date](/docs/date) function on the argument.   |

## Notes

* The function counts both the **start** and **end** dates. If **start** and **end** are the same date and that date is a weekday, the function returns `1`.
* If **end** precedes **start**, the function returns a negative integer of the same magnitude.
* The function treats Saturday and Sunday as weekend days. You can't configure which days of the week the function excludes.
* The function doesn't exclude holidays and does not accept a list of holidays to exclude.
* To find the number of calendar days between two dates rather than the number of weekdays, use the [DateDiff](/docs/datediff) function.

## Examples

```
BusinessDays(Date("2024-02-01"), Date("2025-02-01"))
```

Counts the weekdays between February 1, 2024 and February 1, 2025 and returns `262`.

```
BusinessDays(Date("2025-02-01"), Date("2024-02-01"))
```

Counts the weekdays between the same two dates in reverse order and returns `-262`.

```
BusinessDays([Order Date], [Ship Date])
```

Returns the number of weekdays between the date in the *Order Date* column and the date in the *Ship Date* column.

```
BusinessDays([Invoice Date], Today())
```

Returns the number of weekdays between the date in the *Invoice Date* column and the current date.

## Related resources

* [DateDiff](/docs/datediff)
* [Weekday](/docs/weekday)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Sigma Quickstart: Common date functions and use cases
  </a>