Posted to microsoft.public.excel.programming

Raymond Allan[_2_] Raymond Allan[_2_] is offline

external usenet poster

Posts: 9

Split Monthly Forecast into Weekly Buckets

Thanks Claus, unfortunately it only calculates correctly up to the 30th Nov date, data is correct for 2nd Nov to 30th Nov, the next batch should be 30th Nov 2015 to Jan 4th 2016, there is zero for the 7th, 14th, 21st & 28th Dec but a quantity of 25 for the 4th Jan ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Weekly Forecast to Montly	[email protected]	Excel Programming	1	December 18th 06 07:05 PM
Queation about monthly and weekly averages	Omkar	Excel Worksheet Functions	4	June 17th 06 07:43 PM
Weekly and Monthly Subtotals	ChuckW	Excel Discussion (Misc queries)	3	September 2nd 05 09:58 PM
How do I forecast monthly and annual totals from previous year's .	Jeff Hart	Excel Worksheet Functions	0	April 1st 05 07:19 PM
Weekly, Monthly Sums	Grover[_2_]	Excel Programming	2	May 2nd 04 07:49 PM

All times are GMT +1. The time now is 01:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us