=WEEKNUM(A1)-WEEKNUM($A$1)+1

copy down as far as needed


"Emilio S." wrote:

Hi, trying to figure out a formula to populate column c, where it would
reflect the week of the month. This would be calculated off the value in
column A.
Please help.
Thanks,
Emilio

A B C
11/1/2007 Thursday 1
11/2/2007 Friday 1
11/3/2007 Saturday 1
11/4/2007 Sunday 2
11/5/2007 Monday 2
11/6/2007 Tuesday 2
11/7/2007 Wednesday 2
11/8/2007 Thursday 2
11/9/2007 Friday 2
11/10/2007 Saturday 2
11/11/2007 Sunday 3
11/12/2007 Monday 3
11/13/2007 Tuesday 3
11/14/2007 Wednesday 3
11/15/2007 Thursday 3
11/16/2007 Friday 3
11/17/2007 Saturday 3
11/18/2007 Sunday 4
11/19/2007 Monday 4
11/20/2007 Tuesday 4
11/21/2007 Wednesday 4
11/22/2007 Thursday 4
11/23/2007 Friday 4
11/24/2007 Saturday 4
11/25/2007 Sunday 5
11/26/2007 Monday 5
11/27/2007 Tuesday 5
11/28/2007 Wednesday 5
11/29/2007 Thursday 5
11/30/2007 Friday 5