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 andrewsexceltips.net All Rights Reserved.