Thread: Etimation of future value based on LINEST

I would like to use a formula in order to predict the date (based on a linear regression of values against the dates they were recorded) that a column's last used cell will fall outside a given criteria. I would like this to be automatically updated each time another value is entered into the date column and value column.

For example from the attached:

I would like to predict what the date will be when the value of Column L will be >50

Any ideas? Thanks!

I'm still stumped

What number will fall outside of what criteria? Your workbook doesn't provide a hint ...

The Value of column L (Labled Ethane) will eventually be greater than 50. I would like to predict the date that this will occur. Additional dates and their corresponding values will be added to this sheet from time to time, therefore providing more data points.

Is there a way to predict the date at which a number will reach a certain value? I've been looking into the TREND function but I'm still having trouble getting it to work. Any ideas would be helpful.

Thanks!

wow I'm dumb... yea I had it right before I just forgot to change the the cell format to "Date" so it was coming up as some arbritrary number. Thanks!