View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cwrm4@yahoo.com is offline
external usenet poster
 
Posts: 12
Default Convert Weekly Forecast to Montly

Hello -

I'm building a forecasting tool in Excel for my company that will
generate a weekly forecast based on historical data.I need to be able
to roll-up this forecast up into monthly buckets for budgeting and
long-range planning purposes.

My plan is to evenly distribute the weekly number into the (work) days
of that week, and then roll-up the workday forecast to the respective
months. Does anyone have any code snippets/tricks that will do this?

Thanks, Will