how do I sort a spreadsheet of daily events into weekly totals?

[polly]

I have a worksheet containing figures reported on a workdate daily basis; I
wish to split it into totals by a weekly basis; can I create a formula to
sort the data in weekly totals?

 

[Dave]

Hi Polly,
You can probably use the WEEKNUM function, but you will have to install the
Analysys Toolpack if you haven't already done so.
Then you can use SUMIF and WEEKNUM to sum all results from any given week.
Regards - Dave.