Calculate Business Days only

building reports webintelligence
1

Hi, at the moment I am creating a new report, that should result the days between DATE1 and DATE2 but without Saturday(s) and Sunday(s). Started to create some stuff with DaysBetween Formula built some loops and that stuff but nothing worked out.

Anybody got an idea how to solve that problem?
Thanks in advance!!

##rgds
simon

simonk (BOB member since 2009-01-29)

2

Check this topic and see if it help you.

Jansi :india: (BOB member since 2008-05-12)

3

Well that works (create 3 variables and so on) and I also had this solution before, but when the period starts from Sat or Sunday the result is 0 ?!

simonk (BOB member since 2009-01-29)