Thread: 3 Weeks Forecast-Excel 2003
View Single Post
  #5  
Old June 18th, 2009, 03:01 PM posted to microsoft.public.excel.worksheet.functions
Denver
external usenet poster
  
Posts: 91
Default 3 Weeks Forecast-Excel 2003
Thank you Lori and Jacob Skaria

"Jacob Skaria" wrote:

With the table in below format starting from ColA row1 with the week headers

Wk1 Wk2 Wk3 Wk4 Wk5 Wk6
6728 6732 9034 xx xx xx

the formul in D2 would be
=FORECAST(COLUMN(),$A2:C2,COLUMN($A1:C1))

Copy that to the right as required....

If this post helps click Yes
---------------
Jacob Skaria


"Denver" wrote:

Hi,
Jan3-8 Jan10-15 Jan17-22 Jan24-29
Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7
RcvdRL 6728 6732 7462 9034

I have this data in my excel, I want to make a forecast out of this data
in three weeks period.

I want to know what is my X, my Known_y's and known_x's? I'm not really
familiar
of any excel forecast fomula.

I appreciate for any help

thanks