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