addBusinessDays

Modified on Sun, 02 Apr 2023

This function allows you to add a certain number of workdays (Monday to Friday) to a given date, without including weekends in the calculation.

Syntax

addBusinessDays(date, number)

Returns

Return ValueDescription
DateNew date is calculated by adding the specified number of business days to the original date while excluding weekends from the calculation.

Sample

addBusinessDays(2023-04-03, -5) returns 2023-03-27