JRS: In article <11**********************@f14g2000cwb.googlegroups .com>
, dated Fri, 11 Mar 2005 06:07:07, seen in news:comp.lang.javascript,
Andrew Taylor <an***********@cantab.net> posted :
Dr John Stockton wrote: Throughout
...
--
© John
...
There some good stuff on week numbers at
http://www.cpearson.com/excel/weeknum.htm
Please trim your quotes, according to agreed Usenet standards and the
newsgroup FAQ.
I know of that page; it's not bad, but could do with further work (as at
the beginning of March).
It omits reference to the 2000 & 2004 editions of ISO 8601.
It calls Randy's "military" weeks "Absolute", a term which would better
be reserved for a week count from Week 0 starting with CJD 0.
I cannot comment on its Excel algorithms, but its VBA ones are sub-
optimal though probably giving correct answers.
It ignores schemes such as numbering the rows of the year's calendar, as
in this year's
1 2 row 1
3 4 5 6 7 8 9 2
10 11 12 13 14 15 16 3
....
--
© John Stockton, Surrey, UK. ?@merlyn.demon.co.uk Turnpike v4.00 MIME. ©
Web <URL:http://www.merlyn.demon.co.uk/> - w. FAQish topics, links, acronyms
PAS EXE etc : <URL:http://www.merlyn.demon.co.uk/programs/> - see 00index.htm
Dates - miscdate.htm moredate.htm js-dates.htm pas-time.htm critdate.htm etc.