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())
​
​
​

DAYS

ADD_YEARS

Last modified 9mo ago