"Kurt" wrote in message
...
"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.

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.

I don't know where nsv finds his WEEK() function, as it doesn't seem to be
an Excel function, but for your revised question, try
=WEEKNUM(A1)-WEEKNUM(DATE(YEAR(A1),MONTH(A1),1))+1
--
David Biddulph