Automatically Show Numbers of Last 12 Weeks

[adamas]

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 current one). There's an example file attached.

I'd really appreciate any suggestions, since this one got me stumbled a bit?

Example file here: https://www.dropbox.com/s/4vs622kgbv...bers.xlsx?dl=0

 

[Smitty]

Note that a lot of people either can't or won't download workbooks from untrusted sources.

If you follow the HTML Maker link in my sig you'll be able to post a screen shot(s).

 

[adamas]

Note that a lot of people either can't or won't download workbooks from untrusted sources.

If you follow the HTML Maker link in my sig you'll be able to post a screen shot(s).

Well, with all due respect, but if I can't attach a 8 kilobyte file, what am I supposed to do here exactly?
Many thanks in any case, I'll try to use that HTML Maker thing, but frankly-speaking that's not the most user-friendly way to do this.

 

[adamas]

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
2	What I'm lookin for
3	A formula to be filled in all 12 cells that would
4	Always display the most recent 12 weeks (less/minus current one) dynamically, simply showing number of each of passed weeks
5	In cases if number of current weeks is less than 12, it would automatically display available weeks and leave other cells blank (example A and B). Meaning in this case it should not count down below week 1 (e.g. not show 52, 51, etc)
6
7
8
9
10
11	Result formula should show at various points in time:
12
13	A)	At Calendar Week 5 (current week should be exluded):
14				1	2	3	4
15
16	B)	At Calendar Week 10 (current week excluded):
17				1	2	3	4	5	6	7	8	9
18
19	C)	At Calendar Week 14 (current week excluded):
20				2	3	4	5	6	7	8	9	10	11	12	13
21
22	D)	At Calendar Week 52 (current week excluded)
23				40	41	42	43	44	45	46	47	48	49	50	51
Sheet1

 

[Smitty]

Well, with all due respect, but if I can't attach a 8 kilobyte file, what am I supposed to do here exactly?
Many thanks in any case, I'll try to use that HTML Maker thing, but frankly-speaking that's not the most user-friendly way to do this.

I never said you couldn't. I just pointed out that you limit your potential audience. For instance, my corporate settings don't allow me to access file sharing sites.