/    /  Amazon QuickSight – addWorkDays

Amazon QuickSight – addWorkDays

 

The ADD_WORKDAYS function in Amazon QuickSight allows you to add a specified number of workdays to a date or time value. This function only adds business days, excluding weekends and holidays. 

Syntax

#Start#
addWorkDays(initDate, numWorkDays)
#End#

 

The function takes two arguments

  1. initDate: a date or time value to which the workdays will be added. This can be a date or time literal, a column in a data set, or another calculated field.
  2. numWorkDays: a numerical value representing the number of workdays to add. For example, if you want to add 5 workdays to a date, numWorkDays would be 5.

Example

#Start#
ADD_WORKDAYS("2022-01-01", 5)
#End#

 

This will add five workdays to the date “2022-01-01”, and the result will be “2022-01-10”.

Note that the holidays and weekends to be excluded can be configured in QuickSight’s administrative settings.