 Former Member

# Days between month

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

10|10000 characters needed characters exceeded Former Member
Sep 05, 2014 at 01:42 PM

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

10|10000 characters needed characters exceeded
• Former Member

Hi Anuj

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

Thanks & Regards,

Vinay

• Former Member
Sep 05, 2014 at 01:23 PM

Hi Vijay,

Could you explain bit more what is your requirement.

Does the formula you have written not working?

~Anuj

10|10000 characters needed characters exceeded
• 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

• Sep 05, 2014 at 01:35 PM

Hi Vinay,