Counting of task due date in Qlik Sense

[#1]

Hi,

Need help. I have an issue with counting the due date of a task, if the start date of the task falls on weekend. The due date for a task is 5 working days from the start date.

For example.

If the start date is 18/03/2017, with 5 working days, the task should be due on 27/03/2017.

If the start date is 19/03/2017, the task is also due on 27/03/2017.

I tried using Lastworkdate but can't make it work for both Saturdays and Sundays.

Any suggestions?

[sunny_talwar]

18/03/2017 was a Saturday and 5 working days from Saturday will be until Friday? Friday was 24/03/2017, how are you getting 27/03/2017?? Do you need one extra day? May be this

LastWorkDay([start date], [working days] + 1) as [due date]

or

LastWorkDay([start date], 6) as [due date]