Excel

[Angelo]

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.

[Zygan]

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