How do i make excel show me the previous 3 weeks data sorted by weekly
periods which move weekly
eg previoius week this week would be 26/05/06
and next week the date should change automatically to show 2/6/06 and the
previous 3 weeks.

i dont know the answer to your question i once tried the looking myself
the most i came up with was autofilter on date until i stumbled on
freeze panes. Not sure if you know this or not but you can see how it
works just scroll using the horizontal bar. and the weeks will
disappear but the totals and sums will still work. Click on window
freeze panes make sure you select a column first or row however


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547727