Days between month

[Former Member]

Hi ,

I have requirement to have Days between month should be in following format

Days  0-7     8-15      16-22     23-29  

           1        9              18        24

            3         12           22       28

=If([ number]=0)Then("0-7") ElseIf([ number]Between(8;15))Then("8-15")

ElseIf([ number]Between(16;22))Then("16-22")ElseIf([ number]Between(23;29))Then("23-29")

ElseIf([ number]>=30)Then("30")

Thank you,

Vinay

[Former Member · Accepted solution]

Hi Vijay

Try This

=If [ number]>=0 and [ number]<=7 Then "0-7" ElseIf  [ number]>=8 and [ number]<=15 Then "8-15" ElseIf [ number]>=16 and [ number]<=22 Then "16-22" ElseIf [ number] >=23 and [ number]<=29 Then "23-29" ElseIf [ number]>=30 Then "30"

Please put screenshot if this is also not working.

~Anuj

[Former Member · Accepted solution]

Hi Anuj

Got it But ur answer is alo working fine Thanks for Reply

Thanks & Regards,

Vinay

[former_member210032]

Hi Vinay,

This link will help you

BOBJ Tricks: Workdays Between Two Dates in Webi

Regards

Mustafa

[Former Member]

Hi Vijay,

Could you explain bit more what is your requirement.

Does the formula you have written not working?

~Anuj

[Former Member]

Hi Anuj,

The formula which i have written is showing only 0 or 30 but i require the above format

Thank you

Vinay