Maybe this will be useful to you...

Step1: (If your weekly-date is in column B) Make a new column near your
data, with formula in each line as "=eomonth(b1,0)"
This will bring month value of each data-line, so later you can
summarise/condense your data through this column value.

Step2: In your monthly summary, use reference to this newly made column
instead of weekly-date column.

--
Regards,
Pritesh


"Khimasia" wrote:

Ive got a string of weekly data ranging from 1993-2010, which i need to
convert from weekly to monthly.

Id like to do this so that in the future new weekly data can be
automatically converted to its monthly average.

Whats the best way to do this?