Would appreciate advice on how to calculate the weeknumber of a month.
For example, Feb 28, 2007 is at 5th week of Feb
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

=ROUNDUP((A1-(A1-DAY(A1)+1-WEEKDAY(A1-DAY(A1)+1,3)))/7,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaylin" wrote in message
...
Would appreciate advice on how to calculate the weeknumber of a month.
For example, Feb 28, 2007 is at 5th week of Feb
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Hi

I think the easiest way is to use a hidden sheet, where all weeks for some
period long enough are listed (I myself use the format yyyy.ww for week
number - not Excel format of course, but I calculate week numbers in such
way). Then you have to calculate for every week the date for 1st day of
week, and at last you calculate for every week the month the week belongs to
(For month numbers I use format yyyy.mm). As much as I knew, there is no
uniform definition how to decide to which month a week belongs. I myself
count the week to month, into which belongs Wednesday - because without
holidays then at least 3 workdays are falling into this month.

From such a table is it relatively easy to calculate the number of week in
month.

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Jaylin" wrote in message
...
Would appreciate advice on how to calculate the weeknumber of a month.
For example, Feb 28, 2007 is at 5th week of Feb
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

A1 =Feb 28, 2007

B1 =WEEKNUM(A1)-WEEKNUM("2/1/2007")+1

"Jaylin" wrote:

Would appreciate advice on how to calculate the weeknumber of a month.
For example, Feb 28, 2007 is at 5th week of Feb
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******