weeknum in Excell should return the correct week in 2005 (same as.

[Guest]

The weeknum (analyses toolpack 1) function in Excel returns the week+1 in
2005. The year 2005 start with week 53 for january first and second.

In Outlook the correct weeks are shown.

 

[Nick Hodge]

Alex

This is under the ISO week numbering format...check this out

http://www.cpearson.com/excel/weeknum.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)