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.