# Calculating Future Date from value over time

#### birko61

##### New Member
Good Evening,
Help please from the formula gurus. Imagine two coordinates, X = Date and Y = Value. If the value has risen from zero on day 1, to 30 on day 15, how do I calculate the date in the future, if I was to draw a line (radius) from value 0 to value 30 and swing the arc back down to the date line (to zero)?

regards
Birko

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
It appears that you want to derive the date based on the value.

If column A holds the dates starting from A1 and column B holds the values starting from B1, in A2 enter the formula:

=\$A\$1 + (B2/2) which can be copied down.

A1 should hold a true date.

If my answer is off-track, please post again with a restatement of your problem.

Thanks for your reply. I will paste a visual representation from excel if you anyone can help me paste it here??

thanks
Birko
[/img]

Replies
8
Views
346
Replies
1
Views
360
Replies
5
Views
413
Replies
12
Views
554
Replies
2
Views
386

1,202,917
Messages
6,052,557
Members
444,592
Latest member
fauxlidae

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back