Forum Discussion
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...
Tygra_1983 You don't really give away much but perhaps the attached workbook inspires you to find a solution.
I mean for the date to change automatically once the 'Days to Go' = 0. So once the 'Days to Go' = 0, 28 days will be added on automatically.
Tygra_1983 I would introduce a helper column with the day number of the direct debit and then use a formula to calculate the next due date.
A quick-and-dirty solution in the attached file.
Edit: Uploaded the wrong file. Corrected now.
- Thanks Riny_van_Eekelen. But could you explain the IF formula you have used in the E column? I'm not so advanced with Excel. I can only use simple IF formulas.
Thanks
