Business Days help

[mahitham]

Hi,

I have the Actual Date field like below in the attached QVD.

Could you please help me to add 35 business days.

I have null values also in Actual Date for those need to skip business days adding.

Requirement:

Now from this [Actual Date] I need to derive a New field called [Estimate Date] like below i.e.,

Value of [Actual Date] field + 35 business days

A “business day” is defined as any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.

Please help me on this.

Thanks in advance

[vitaliichupryna · Accepted solution]

Hi Mahitham,

You can use lastworkdate function:
lastworkdate([Actual Date], 35) AS NextDate

Thanks,
Vitalii