Date functions

BusinessDays

View as Markdown

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.

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 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 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 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.