Projected/Forecasted Date from values

hi all,

i've been trying to work this out however i'm getting nowhere.

I require to forecast a date from now which would factor in usage number per day.

i have the projected values for X and Y and want to know if theres a way utilising the daily usage for X,Y to project a date in the future using these values.

For example X Daily Usage is 3.32 , X Projected value is 15635. projected date would be 20/04/2028 - is this possible?

i've marked the yellow cells as to where i require this date.

many thanks

Try this for x:

=TODAY()+INT((D3-B3)/B9)

But that gets to date 10/Feb/2031.

Thanks Estevaoba

I'm now looking to plot this info into a graph.

So, i'd like to see X projected calendar date plotted to the dates listed in column F with a dotted line being present on the graph where X cut off date is column G

i've included an image to show what im wanting, the projected dates in F as the X axis and X projected (columb D) to be the Y axis then is it possible to add a dotted line where X cut off date lands similar to the below (blue dotted line)
Capture.PNG

i require to do this for Y projected too.

see attached for updated Spreadsheet.

Many thanks

is this possible? feel free to suggest an alternate method of showing a similar output if you have any ideas. many thanks guys!