Custom Week Numbers

[Kristofer]

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

 

[jim may]

Excel 2010
	A	B
1	Date	Week #
2	2/25/2013	1
3	3/4/2013	2
4	3/11/2013	3
5	3/18/2013	4
6	3/25/2013	5
7	4/1/2013	6
8	4/8/2013	7
9	4/15/2013	8
10	4/22/2013	9
11	4/29/2013	10
Sheet1

Cell Formulas
Range	Formula
B2	=WEEKNUM(A2,1)-8
B3	=WEEKNUM(A3,1)-8
A3	=A2+7