From Excel's Help Menu:
FORECAST:
Calculates, or predicts, a future value by using existing values. The
predicted value is a y-value for a given x-value. The known values are
existing x-values and y-values, and the new value is predicted by using
linear regression. You can use this function to predict future sales,
inventory requirements, or consumer trends.

Syntax
FORECAST(x,known_y's,known_x's)

TREND:
Returns values along a linear trend. Fits a straight line (using the method
of least squares) to the arrays known_y's and known_x's. Returns the y-values
along that line for the array of new_x's that you specify.

Syntax
TREND(known_y's,known_x's,new_x's,const)

Finally, you can use dates in the column adjacent to your data.

Regards,
Ryan--

--
RyGuy


"Nick Anderson" wrote:

I work for a company that is wanting a run rate to determine the number of
polices that we are going to sell by the end of the month. We have a goal
already preset and they want to know as each day passes where we are going to
be at for the end of the month for policies. I have used the forecast
function but it does not seem to be working. I dont have two rows of data
only one, can some one help me to determine if the Forecast function is the
correct on to be using or is there something better?