Non calendar months - 1st Monday in Month

[Sayth]

I am trying to use a cell formula to determine weeknum. The first monday of the month is the first week.

I have adapted this formula from here http://www.cpearson.com/excel/WeekNumbers.aspxto this

=TRUNC(((B3-DATE(YEAR(B3),1,1)+MOD((1 = Monday)-WEEKDAY(DATE(YEAR(B3),1,1)),7))+6)/7)

b2 has my day in dd/mm/yyyy format. Can't quite get it to work though, any ideas.

 

[Sal Paradise]

I am still unclear on what exactly you are looking for. You just want a formula that says:
If B2 = January Then January Week 1, Week 2, Week 3, Week 4 in cells C2-E2?

 

[Sayth]

I am still unclear on what exactly you are looking for. You just want a formula that says:
If B2 = January Then January Week 1, Week 2, Week 3, Week 4 in cells C2-E2?

I will find a picture. Its in nearly every pivot table ever created I just don't know the words to describe it.

 

[Sayth]

So this is the date picker in pivot table I am referring to.

But this is impractical in reality you can't have managers and technophobes selecting every day in each month or each week everytime. So I want to pre bundle/group the dates into Months & weeks.

the month selectors in here are also impractical as they aren't adjustable(to my knowledge) to reporting cycles.

 

[T. Valko]

So this is the date picker in pivot table I am referring to.

But this is impractical in reality you can't have managers and technophobes selecting every day in each month or each week everytime. So I want to pre bundle/group the dates into Months & weeks.

the month selectors in here are also impractical as they aren't adjustable(to my knowledge) to reporting cycles.

Sorry, I don't have any other suggestions.

 

[Sayth]

I can group in my pivot table drop down filter by craeting a column in my datasheet and using month(b2), any ideas how to group weeks under months.