Just a heads up if you send the file(s) to someone else, WEEKNUM is part of
the Analysis ToolPak and many users in a corporate environment might not
have it installed (they'll get a name error)
--
Regards,

Peo Sjoblom

(No private emails please)


"BarrySandell" wrote in message
...
Thanks for your responses. I thought of a simple solution about 5 minutes
after posting my question. Typical!

Use the WEEKNUM function to convert each date into the number of the week
in
which it appears, then use a pivot table to sum the values for each week.
To
convert the weeknum back to a date (eg for plotting on a chart), add the
week
number * 7 to the Excel index number for 1st Jan, then format the result
as
d/mm/yy. Works every time!

"BarrySandell" wrote:

I have an Excel spreadsheet of daily totals where some days have no
values
and some days have several values. I want to consolidate this into weekly
totals. Any ideas?