Change cell date when another cell value increases.

[RussPhi]

I fave a cell A2 with a date 2-17-2017 and the other cell is summing up from 12 other cells Jan - Dec (sum cell B15)
how can I change the date (A2) by a month each time B15 value is increased by $30.00. I hope I explained this well.
is there a function I can use.

Russ

 

[NoSparks]

What if every increase to B15 is $10.00, then it would never be increased by $30.00 ?
Or do you store an original value somewhere ?

 

[AlphaFrog]

I fave a cell A2 with a date 2-17-2017 and the other cell is summing up from 12 other cells Jan - Dec (sum cell B15)
how can I change the date (A2) by a month each time B15 value is increased by $30.00. I hope I explained this well.
is there a function I can use.

Russ

What is the formula in cell B15 ? It matters.

Do you want to increase the date by one month for each $30 increase (so add one month at 30, 60 ,90...) or do you want to add just one month if the sum increases say $120 in one calculation?

 

[RussPhi]

what I would like to see is each month there is an increase of $30.00 so is it possible to change the date A2 so I would know that the person I'm tracking is payed up to the next month.
so it can work either by the month each cell or by the auto sun cell that has =sum(b3:b14) as they pay 30 a month I add 30 to the cell adjacent to the month cell.

 

[NoSparks]

Look into the DATE function
The month number would be B15/30 for number of months paid.

 

[AlphaFrog]

Put this formula in cell A2.
2/17/2017 is the start date for your pay schedule. Change it to suit.

=EDATE(DATEVALUE("2/17/2017"), B15/30)

 

[RussPhi]

got it it works. thanks