Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparable week numbers overs years
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparable week numbers overs years
Hi Joël,
To learn all about week numbers and implementations in Excel, visit: http://msdn2.microsoft.com/en-us/library/bb277364.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Joël" wrote in message ... |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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparable week numbers over years | Excel Discussion (Misc queries) | |||
Moving week numbers | Excel Worksheet Functions | |||
I need to =a set of numbers to a given week day.ie 6031 = Wed ect | Excel Discussion (Misc queries) | |||
Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
Week Numbers | Excel Discussion (Misc queries) |