software

I know I've done this before but can't remember how.

How do you find the number of the week in a given month?
--
maryj

well it depaneds on how you define the week number.

If the 8th marks the start of the 2nd week, and so on then just take
int(day(the date)/7)

if you want the quot;wweksquot; to all start on Monday, for example it's more
complicated

quot;maryjquot; wrote:

gt; I know I've done this before but can't remember how.
gt;
gt; How do you find the number of the week in a given month?
gt; --
gt; maryj

Maybe I am mistaken that I have done this before - thought I had, but who
knows. I would want May 2, 2006 to be week 1, May 10th to be week 2, etc.

--
maryjquot;duanequot; wrote:

gt; well it depaneds on how you define the week number.
gt;
gt; If the 8th marks the start of the 2nd week, and so on then just take
gt; int(day(the date)/7)
gt;
gt; if you want the quot;wweksquot; to all start on Monday, for example it's more
gt; complicated
gt;
gt; quot;maryjquot; wrote:
gt;
gt; gt; I know I've done this before but can't remember how.
gt; gt;
gt; gt; How do you find the number of the week in a given month?
gt; gt; --
gt; gt; maryj

I used this formula which is close most of the time -
=INT((DAY(A2)-1)/7) 1
--
maryjquot;maryjquot; wrote:

gt; Maybe I am mistaken that I have done this before - thought I had, but who
gt; knows. I would want May 2, 2006 to be week 1, May 10th to be week 2, etc.
gt;
gt; --
gt; maryj
gt;
gt;
gt; quot;duanequot; wrote:
gt;
gt; gt; well it depaneds on how you define the week number.
gt; gt;
gt; gt; If the 8th marks the start of the 2nd week, and so on then just take
gt; gt; int(day(the date)/7)
gt; gt;
gt; gt; if you want the quot;wweksquot; to all start on Monday, for example it's more
gt; gt; complicated
gt; gt;
gt; gt; quot;maryjquot; wrote:
gt; gt;
gt; gt; gt; I know I've done this before but can't remember how.
gt; gt; gt;
gt; gt; gt; How do you find the number of the week in a given month?
gt; gt; gt; --
gt; gt; gt; maryj