I need to build a calculated column that adds a number of workdays to a date . I would like to add the workdays based off the US factory calendar which has the US Holiday calendar associated with it.
Using the adddays function while factoring in the days of the week to skip over weekends, does not allow me to account for holidays which are applied to the SAP factory calendar.
Has anyone come up with a way to add workdays, based on a specific factory calendar (US in this case), to an existing date in a calculated column of a HANA model? If so, would you please share.
Thank you in advance.