ADD_WEEKDAYS takes a date, from either an information or in ISO8601 format, and a number of weekdays to add, and returns a date with the given number of weekdays added. For this calculation, weekdays are all days of the week except for Saturday and Sunday.

Example: Date

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

This returns 2000-01-17T00:00:00. This actually added 17 days since weekends were ignored when adding.

Example: Date with time

If you specify not just a date, but a date and time in ISO8601 format, the function includes the time in the calculation.

ADD_WEEKDAYS('2000-01-01T09:35:23', 10)

This returns also the 17th January 2000, but at 9:35:23, so 2000-01-17T09:35:23.

Last updated