What is my x-value in a trendlinde based on dates?

[RSunday]

I have made a chart showing prices every month. Now I have added a trendlinde
and can see the formula.

If I want to calculate the exact "trend-price" - what is then my x-value for
a given month?

 

[Andy Pope]

Hi,

You will find information on the LINEST formula, which will allow you to
create formula to resolve your problem.
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

Cheers
Andy

 

[RSunday]

...thank you - but this is not exactly easy-reading.

Is there a simple hint on how to use the trendline formula to calculate
sales for a given future month - then please give an example.

 

[Jon Peltier]

What form are your dates in? What is the base unit of your date axis (months
or days), or is it really a text label axis? What's the trendline formula
look like? The answer to your question depends on the answers to these.

- Jon