comparable week numbers over years

=?Utf-8?B?Sm/Dq2w=?=

Guest

Posts: n/a

11th Apr 2007

I want to compare weekly results 2006 vs. 2007; by using formula
weeknum(date,2) where date = 02jan06, I get directly week 2 (week 1 being one
day = 01jan06)
However, in 2007, week 1 begins on Monday 01jan07
I compare then apples and pears !
I could do it manually but a formula would be 'the' solution !
I suppose, this is a trivial question but any possible clue will greatly
help me !
JoÃ«l

« Excel Shared Worksheet | Cell colours not showing »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I display week numbers when the week runs Saturday to Frida	milly54	Microsoft Access VBA Modules	1	14th Aug 2008 03:14 PM
comparable week numbers overs years	=?Utf-8?B?Sm/Dq2w=?=	Microsoft Excel Misc	1	16th Apr 2007 03:33 PM
Same Week, Different Years....	prosfora	Microsoft Access Queries	3	19th Mar 2006 04:10 AM
Google is 7 years old this week!	Ian	General Discussion	15	12th Oct 2005 01:57 PM
Re: how do I show Week numbers in outlook calendar, example week 1 (0.	Milly Staples [MVP - Outlook]	Microsoft Outlook Calendar	4	6th Sep 2004 03:22 AM