WEEKDAYS
Description
Example
WEEKDAYS('2022-12-01', '2022-12-12')Example with a datetime
WEEKDAYS('2022-12-01T13:49:23.191Z', '2022-12-12')Last updated
Was this helpful?
WEEKDAYS takes two dates and returns the number of weekdays (Monday–Friday) between them. The order of the arguments does not matter.
WEEKDAYS('2022-12-01', '2022-12-12')This returns 7, as there are 7 weekdays between 1 December and 12 December 2022.
WEEKDAYS('2022-12-01T13:49:23.191Z', '2022-12-12')Datetime values are supported — this also returns 7.
Last updated
Was this helpful?
Was this helpful?