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 if there is anyway I can update these dates once the day has arrived and the money is taken out? For example, something comes out on the 2nd of July. Once the 2nd of July comes the date will automatically be updated to the 2nd of August. Can this be done?
Thanks,
34 Replies
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.
