=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*******