I've been creating a spreadsheet that takes figures from specific dates
and summarises into weeks and came accross this problem..
E.g.
=WEEKNUM("20/9/2005")
returns '39'.. it is however week 38!
However, using dates from last year e.g.
=weeknum("14/10/2004")
it returns the correct week 42.
Is it me or is this a bug?... i've tried looking for some sort of patch
but no joy!
--
madhatter_scfc
------------------------------------------------------------------------
madhatter_scfc's Profile:
http://www.excelforum.com/member.php...o&userid=27255
View this thread:
http://www.excelforum.com/showthread...hreadid=469294