Week Number (Absolute)

Pearson Software Consulting http://www.cpearson.com/

=TRUNC(((A1-DATE(YEAR(A1),1,0))+6)/7)

This is something I put together.

=INT((A1-DATE(YEAR(A1),1,1))/7)+1



© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.