flummi Wrote:
You could use this type of formula:

15.03.2006 Week 12 <-- ="Week "&WEEKNUM(A1,2)

Hans

Thank you for the suggestion Hans but I do not quite understand
.

the Weeknum formula returns a value based on the week of the year does
it not?

I need am trying to return the week of the semester, which started on
27th Feb 2006.

Chris


--
christopherp
------------------------------------------------------------------------
christopherp's Profile: http://www.excelforum.com/member.php...fo&userid=4162
View this thread: http://www.excelforum.com/showthread...hreadid=524020