Greetings All,

I have the following array of data, column 1 is the date and column 2 is the
amount in US$. I am trying to use regression to forecast three years or so
hence.

3-Jan-06 750,000
3-Apr-06 1,000,000
27-Apr-06 1,009,778
14-Jul-06 1,139,739
26-Oct-06 1,109,484
5-Dec-06 1,169,886
9-Jan-07 1,244,587
10-Mar-07 1,421,393
28-Mar-07 1,419,597
14-Aug-07 1,642,892

If I use a linear regression trendline on this data, the R^2 is around 90%
which is not bad. If I use the "Forecast Forward Periods" function, this
gives me an idea of when the regression line passes 2,000,000 or 2,500,000.
However, my question is this: what is the correct x-value input to use with
the regression equation

y = 1332.4x - 5E+07

since using the 1900-calendar number clearly does not work.

Many thanks,

Peter SS