Forum Discussion

Tygra_1983's avatar
Tygra_1983
Copper Contributor
Jun 22, 2021

Updating Dates in Excel

Hi there,   I am doing a worksheet for my finances. I have a column with my direct debits and the dates within the next month that they will be taken out of my account. What I would like to know is...
excel
Formulas and Functions
Tygra_1983's avatar
Tygra_1983
Copper Contributor
Jun 24, 2021
Thanks again guys for all your help. However, I would like to ask another question: how do I perform a calculation where once the value reaches zero it automatically resets to the original value. Like say there is a countdown from 14, once it reaches 0 it automatically goes back to 14? What formula would you use?

Thanks again
mathetes's avatar
mathetes
Silver Contributor
Jun 24, 2021

Tygra_1983 

 

You asked: how do I perform a calculation where once the value reaches zero it automatically resets to the original value. Like say there is a countdown from 14, once it reaches 0 it automatically goes back to 14? What formula would you use?

 

To which I have to respond, it all depends. There's not a single answer, unfortunately. It depends on how the data are arrayed, how that countdown itself occurs and how it's displayed. Is it a daily reduction by one, a reduction by one every time "X" occurs; is it even a reduction by one, or can the countdown be more random? You see what I mean?!

 

You'd probably need a helper column again, but as noted so very much depends on the rest of the process.

 

=IF(X=0,Y=14,Y=X) or some variation might work, but, again, it all depends.

 

Do you have a spreadsheet going where this needs to be resolved? If so, post a copy.

Resources