WEEKDAYS
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.
WEEKDAYS('2022-12-01', '2022-12-12')
This returns
7
, as there are seven weekdays between 1st December and 12th December 2022.DAYS('2022-12-01', TODAY())
Last modified 9mo ago