Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Turn Rate to Weekly Supply | Excel Worksheet Functions | |||
how to convert a weekly data series to monthly | Excel Discussion (Misc queries) | |||
Chart displaying weekly data group in months without weekly labels | Charts and Charting in Excel | |||
I have year based data want to convert into weekly basis | Excel Worksheet Functions | |||
montly summary | Excel Discussion (Misc queries) |