week numbers

Hi, I've been trying to make a list in excel that looks somewhat like this. Week 1 ...... Week 2 ..... Week 2 ...... Week 3 .... Week 3 .... Week 4 .... Skip Week 1 Week 4 ..... Week 1 ..... Skip But I've run amuck every single time. It's hard because i'm trying...

If it is possible please can someone provide the code that will enable me to automate the process of changing filters for week numbers on numerous pivot tables? I produce a weekly report that requires a 10 week period range. Therefore, every week I have to remove from numerous pivot...

I am trying to use the WEEKNUM function but it miss reports the week. example cell function in B7 =WEEKNUM(B6,11) using a date of 29/12/15 reports week 53 (Week 53 is December 28th 2015 to January 3rd 2016) but put a date of 01/01/2016 reports week 1?? It is still part of week 53...

I have Week Numbers in Column A and values in Column B. I would like to be able to Sum the last x weeks of data in Column B based on the current week number. How best to do this? Thanks!

Hey there, guys! I'm trying to come up with a formula that would show week numbers of last 12 weeks. So in case of less than 12 calendar weeks passed it would start countdown with week 1 and show up to current week -1, and in case of more than 12 weeks - simply show recent 12 weeks (minus...

Help please, Problem is in D19 I could have "week 1" up to "week 52" and I would like E19 to plus 1 for example if D19 was "week 1" E19 would be "week 2" or if D19 was "week 40" E19 would be "week 41". Any solutions guys??

Hey guys and gals, I need some help on getting a week number calulated .. I've tried to use WEEKNUM function, but that didnt seem to work out right for me when I saved the file (based on computer system, it always changes In my excel file (uploaded here on Mega.co.nz) I would like cell...

Hi All, I am trying to get the week numbers put in to dates I have in column A, however I want week 1 as 25-Feb and not Jan 1st. Any help? Thanks