Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???

Depends where the week starts, if day 1 then

=N(INT((A1-"2009-02-01"+7)/7))

--
__________________________________
HTH

Bob

wrote in message
...
Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???

If the first date is in A1, then in B1 enter

=INT((DAY(A1)-1)/7)+1

and copy down.

Hope this helps,

Hutch

" wrote:

Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???

;266697 Wrote:
Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???

First, you will have to define what is week 1 in a month for your
puroposes.
Is week 1 the week containing Feb 1st?
The first week were all days are in february?
Do your weeks begin on Mon on Sunday?
Do you use ISO week numbers?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74428

=INT(DAY(A1)/7)+1
and fill it down to row 27!

Regards,
Stefi

€� ezt Ã*rta:

Hi All,
I have dates starting from 02/02/2009 and ending on 02/27/2009 in
Coloumn A. I n coloumn B i want to know, in which week of February,
each day falls.. For Eg:- 02/02/2009 falls in Week1, 02/09/2009 in
Week2 so on... Is there any formula to get this??? WEEK NUM function
starts with January and for above example it gives the result as
Week6, which is not what I am looking for... Is some one could assist
me with???

Thank you!!!