J
Jay
I have a column with Week numbers on it (1,2,3...52). I
have another column with Volumes (2432,4543...etc.). I
would like to convert this weekly volume summary to a
monthly volume summary. So I will have a column with
Months on it (Jan, Feb, Mar... Dec) and another column
with Monthly Volumes (10543, 13434,...) which is the sum
of all the relevant weekly volumes (i.e. Weeks 1 to 4.33
in Jan etc. I know that the detailed method would be
convert weekly volume to a daily volume in a column. So
January will be the sum of Weeks 1, 2 and 3, then for the
fourth week, add volumes for first 3 days (31 days). The
remaining 4 days will go to Feb and so on.
I want to know if there is an easier and more efficient
way to do this in Excel. Note that this method assumes
that the 1st of Jan begins on the 1st day of the week. Is
there a better way to do this??
Hope this explains it!
have another column with Volumes (2432,4543...etc.). I
would like to convert this weekly volume summary to a
monthly volume summary. So I will have a column with
Months on it (Jan, Feb, Mar... Dec) and another column
with Monthly Volumes (10543, 13434,...) which is the sum
of all the relevant weekly volumes (i.e. Weeks 1 to 4.33
in Jan etc. I know that the detailed method would be
convert weekly volume to a daily volume in a column. So
January will be the sum of Weeks 1, 2 and 3, then for the
fourth week, add volumes for first 3 days (31 days). The
remaining 4 days will go to Feb and so on.
I want to know if there is an easier and more efficient
way to do this in Excel. Note that this method assumes
that the 1st of Jan begins on the 1st day of the week. Is
there a better way to do this??
Hope this explains it!