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