Hi there,

Here is a sample of what I'm trying to forecast...

Month Visitors to Store
Jan 50,000
Feb 60,000
Mar 80,000
Apr ?
May ?

The way I understand the FORECAST function in Excel to work is that it
requires numeric values for both the X and Y values. In this case;
however, I believe my X value to be the month, so when I use the
formula "=FORECAST(x,known_y's,known_x's)" I receive an error message.

Am I going about this the wrong way? Is there another function I need
to use?

Many thanks for any help you can offer!!