ADD_WEEKDAYS

Description

ADD_WEEKDAYS takes a date and adds a specified number of weekdays (Monday–Friday) to it, skipping Saturdays and Sundays. Returns the resulting date as a string.

Example

ADD_WEEKDAYS('2000-01-01', 10)

Starting from Saturday 1 January 2000, this skips weekends and returns "2000-01-15".

Last updated

Was this helpful?