Week number

[pranamu]

Dear,

Looking for a help to build week number in excel.
The week will start from Monday and end on Sunday. January 1st till 3rd should be calculated wk1, January 4th till 10th should be calculated wk2 accordingly so on.
I have dates in column A2,A3....... want corresponding week number in column B2,B3....... based on above logic (Monday-Sunday)


Thanks,
Prakash

 

[Habtest]

Hope it helps

Book1
	A	B
1	Date	Week#
2	1-Jan	1
3	2-Jan	1
4	3-Jan	1
5	4-Jan	2
6	5-Jan	2
7	6-Jan	2
8	7-Jan	2
9	8-Jan	2
10	9-Jan	2
11	10-Jan	2
12	11-Jan	3
Sheet1

Cell Formulas
Range	Formula
B2:B12	B2	=WEEKNUM(A2,2)
A6:A12	A6	=A5+1

 

[jtakw]

Hi,

=WEEKNUM(A1,2)

 

[pranamu]

Hi,

=WEEKNUM(A1,2)

that's great, thanks.

 

[jtakw]

You're welcome.

In all fairness, @Habtest beat me to it (may be by a second or two)