WEEKDAYS

Description

WEEKDAYS takes two dates, from either an information or in ISO8601 format, and returns the number of weekdays, so excluding weekends, between the two dates.

If you are looking for the number of total days, use the DAYS operator.

Example

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

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

This operator can also be used in combination with other operators like TODAY or NOW.

DAYS('2022-12-01', TODAY())