| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparable week numbers over 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How do I use week numbers for sub-totalling? | Excel Discussion (Misc queries) | |||
Linear Mode
