Yes. each month to start at week 1.

Kurt

"Toppers" wrote:

Do you mean that each month will start at week 1?

"Kurt" wrote:

Each of the suggestions worked. What if I wanted to limit to the week number
for a particular month. For example if 1/1/06 will be in week1 in Jan-06 and
28/1/06 will be week4 in Jan-06? How can I achieve this.

Kurt

"nsv" wrote:


Oh, but that formula exists and it is called WEEK.
Write your date in A1 and be sure to have the format so that is
interpreted as a date. If you want to be sure just write 38871 which is
the value for 20-07-2006
Then try this in B1: ="Week "&WEEK(A1)

Just one important thing: Americans regard week 1 to be the remaining
of the week containing January 1'st, so week 1 is normalkly shorter
than 7 days.
In Europe week 1 is the first week in a year if January 1'st is
Thursday or earlier; else it is called week 53.
This makes the counts differ in America and the rest of the world and
Excel uses the american way.


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=563275