WEEKDAYS

Description

WEEKDAYS takes two dates and returns the number of weekdays (Monday–Friday) between them. The order of the arguments does not matter.

Example

WEEKDAYS('2022-12-01', '2022-12-12')

This returns 7, as there are 7 weekdays between 1 December and 12 December 2022.

Example with a datetime

WEEKDAYS('2022-12-01T13:49:23.191Z', '2022-12-12')

Datetime values are supported — this also returns 7.