Add days into the date after removing hlodays - Webi report

[Former Member]

Requirement

Suppose today is 24 sep 2018

next 2 days are working days i.e 25 sep and 26 sep

27 sep is government holiday

I want to know the date after 5 working days

24 sep - request came

25 sep - Working day 1

26 sep - Working day 2

27 sep - Govt Holiday

28 sep and 29 sep - weekend

29 sep - Working day 3

30 sep - Working day 4

1 oct - Working day 5

So as per my requirement 5th working day is 1st of October.

How to achieve this?

[amitrathi239]

do you have Calendar table maintained in the Database? Directly it's not possible in webi without maintaining the holiday table in the database.

[Former Member]

yes we have calendar table maintained in the DB

but the thing is we don't have government holiday in that table. as Government holidays are not on fixed days