Convert weekly p&l data to accurate monthly data

Completed Posted Nov 10, 2014 Paid on delivery
Completed Paid on delivery

I want to take a weekly p&l forecast (complete) and create a monthly summary for it.

I want it to accurately reflect the number of days in each month in 2015. For instance, I don't just want to sum the first four week forecast in 2015 and call it January - I want to pull the first 31 days of the forecast (so the first four weeks + 3/7 of the fifth week).

Needs to be dynamic so every time the weekly p&l is updated, the monthly summary is as well.

I know this is a simple set of helper rows and index formulas... I just don't have time to do it. Need completion quickly.

Thank you!

Excel

Project ID: #6709909

About the project

6 proposals Remote project Active Nov 10, 2014

Awarded to:

rahulraut89

Hi, We are a team of MBA graduates with specialization in Finance and Marketing. We have prior experience of doing such projects. We can finish off your task in the desired time with the expected quality. Also we a More

$30 USD in 2 days
(9 Reviews)
4.7

6 freelancers are bidding on average $27 for this job

avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$30 USD in 0 days
(76 Reviews)
5.9
best4best

Please share the existing weekly P&L sheet, I will create a monthly P&L sheet for it as per your description.

$30 USD in 1 day
(84 Reviews)
5.4
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. Feel free to message me with your actual data. Thank you.

$30 USD in 1 day
(3 Reviews)
2.3
khadar1990

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
malinasoftware

I am Swarup from India; I have been working with MsOffice, DTP, Pdf works since 2006. I am eager to work competently with you. So I am waiting for your reply. Hope you will be satisfied with my work. Regards, Swarup More

$15 USD in 3 days
(0 Reviews)
0.0