cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating Workdays

0 Kudos

Hi Webi Gurus,

I have to create a new Webi Report and there i need to calculate a new Date based on Value Date (ValueDate+4 Workdays)

eg.

Value Date                           New Date

20.05.2016  + 4 Workday = 26.05.2016

Can you help me ?

Thanks

Nas

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

use this.

=If(DayName([Value Date])="Monday") Then RelativeDate([Value Date];4) Else  RelativeDate([Value Date];6)

0 Kudos

thanks Amit...

Former Member
0 Kudos

The only thing is that it will not take Public Holidays into account. We need something similar to the excel function Workday(start_date,days,holidays).

Former Member
0 Kudos

People have resorted to do the holiday part in data itself :-

https://scn.sap.com/thread/3546935

0 Kudos

thanks for that.. I solved my problem

Former Member
0 Kudos

You can mark the question as answered and share your solution for the broader audience to close loop.

Answers (0)