Forecasting - dynamic date with array formulas

[Deesupertramp]

Hi!

I would appreciate your help with a formula issue. I'm trying to do a dashboard including a forecast of sales. We have numerous consultants (iOS, Android, Project Managers) working on different clients week after week.

I have attached a sample of the spreadsheet I am working on with the details of what I'm trying to achieved. I want to be able to change the date so that my forecast gets automatically updated with the data for that specific date.

Many thanks for your help

D.

 

[vletm]

If You really try to do forecasting then You'll need much more data,
much more data then You will get much better values of forecasting,
or You'll get one kind of guess.
I tried to make one sample for You.
Colored cells - no forecasting!
Test to change C3-cell date.