HELP! IF Multiple Range & Multiple Criteria

[Melissa Alex]

Hello Guys!

I'm trying to find a way to make a summary of items but depends on week coverage (week 1, week 2, etc.)..
I would also like to indicate the month covering the weeks, i.e. Week 1-4=January; week 1-8=January-February; week 1-12=January-March

I tried using IF but it was ohhhh sooooo long. I wasn't able to input all the formula I need because I reached the
character limit.. Hope you guys can help me find an easier and shorter formula that can come-up with the same data elaborated further below:


IF CELL A2>=1 AND A3<=4 THEN "JANUARY"
IF CELL A2>=5 AND A3<=8 THEN "FEBRUARY"
IF CELL A2>=9 AND A3<=12 THEN "MARCH"

AND SO ON.. AND

IF CELL A2>=1 AND A3<=8 THEN "JANUARY-FEBRUARY"
IF CELL A2>=5 AND A3<=12 THEN "FEBRUARY-MARCH"
IF CELL A2>=13 AND A3<=16 THEN "MARCH-APRIL"

AND SO ON.. AND

IF CELL A2>=1 AND A3<=12 THEN "JANUARY-MARCH"
IF CELL A2>=5 AND A3<=16 THEN "FEBRUARY-APRIL"
IF CELL A2>=13 AND A3<=20 THEN "MARCH-MAY"


AND SO ON.. AND INCREASING WEEK COVERAGE..



Thanks in advance! ^___^

[FDibbins]

can you upload a sample workbook so we can see your layout etc? alos include some samples of what your expected outcome is and how you arrived at that?

[Melissa Alex]

can you upload a sample workbook so we can see your layout etc? alos include some samples of what your expected outcome is and how you arrived at that?

hello dear, here's a sample file for your reference. hope you can help me out..

[Melissa Alex]

hello dear, here's a sample file for your reference. hope you can help me out..

by the way, if you update the blue cells (D6 & D7) in the file there, cell E2 will reflect the month covering the periods in dicated in the blue cells. However, my formula is not complete because of character limit, so basically, it can't cover all possible week coverage

[DBY]

Hello
I hope FDibbins won't mind me offering a possible solution. If you're happy to use a lookup table then perhaps it could be done as in my attached reply. It is possible to hard code the lookup table but this way it's more flexible if you wish to change the monthly break points.

Hope this helps.
DBY

[Melissa Alex]

@ DBY

wooow!! It's perfect!! thank you so much my dear! you're so great!..

Thanks in advance too FDibbins! ^_^

[DBY]

You're welcome. Glad we could help. An example file always makes things easier to work out.

Regards
DBY

[Melissa Alex]

You're welcome. Glad we could help. An example file always makes things easier to work out.

Regards
DBY

will take note of that.. thanks again!