one week occurs in two months - how to handle this?

[josephinetedesc]

Hi

I am getting strange answers when calculating monthly and weekly values - see below

So for example when I choose the month of August, and the x axis is in weeks - I get a week num of week 31, with 100% activity

Thankfully this does not happen very often.  Is there a way of overcoming this problem?

Jo

DateOfInt	WeekNum	month
Sunday, 2 August 2015	32	8
Saturday, 1 August 2015	31	8
Friday, 31 July 2015	31	7
Thursday, 30 July 2015	31	7
Wednesday, 29 July 2015	31	7
Tuesday, 28 July 2015	31	7
Monday, 27 July 2015	31	7
Sunday, 26 July 2015	31	7
Saturday, 25 July 2015	30	7
Friday, 24 July 2015	30	7
		location
month	weeknum	East	Grand Total
7	27	9310	22665	41%
	28	15080	37040	41%
	29	15690	37885	41%
	30	15675	36590	43%
	31	14815	36250	41%
7 Total		70570	170430	41%
8	31	540	540	100%
	32	15500	37435	41%
	33	15060	38495	39%
	34	14915	36795	41%
	35	15575	38055	41%
	36	2975	8095	37%
8 Total		64565	159415	41%
Grand Total		135135	329845	41%

[MRTN1]

Exactly that Swuehl! That is what I am desperately trying to achieve, assign a week to the month that 3 or more working days (Mon-Fri) of a week fall into. So far anything I tried failed. I need to establish this type of week to month relationship/mapping, in order to get clear to understand and easy to explain (sub)totals. I think I have been trying too hard for too long, likely overcomplicating things at this point. Your help in this matter to get be back on the right track is much appreciated Sir! Wkr, Maarten