Count Week Of Month

[Guest]

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

 

[Sandy Mann]

Asuming Labels in Row 1, enter 1 in C2 then in C2 the formula:

=IF(WEEKDAY(A3)=1,C2+1,C2)

and copy down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

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

copy down as far as needed

 

[Guest]

Sandymann, thanks it worked.

Teetless, i don't think excel has a "weeknum" function, or at least my
version (2003) doesn't. But thank you!

 

[Dave Peterson]

=weeknum() is part of the analysis toolpak in xl2003.

Tools|addins and check Analysis toolpak. Depending on if it's installed, you
may need the distribution disk.