Averaging weekly data into Months

K

Khimasia

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?
 
P

Pritesh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Monthly quantities to Weekly 1
Converting daily data into weekly 1
Use icon sets relatively in a pivot table 1
sum weekly data into monthly 1
Trend Data From an updated column 0
Locking cell data from change 1
Divide by last two months depending on report date 0
Is there a way to sum monthly or weekly reports into one report 2

Top