Automatically update dates

[sdbrown]

Hi All,

I am a novice excel user, and currently trying to develop my own sheet to track my household expenses/direct debits by apportioning funds per day in a particular account.

The issue i have, which is easier if you look at the sheet i have attached.. but i would like my column "last Debit Day" to update automatically once the "next due" has passed.therefore "next due" value will be transferred to "last debit Day"

I hope this makes sense. Any help would be greatly appreciated and have come to the conclusion that it probably needs to be done with VB as i cannot figure out formulas to do it.


updating_dates.xlsx

[sourabhg98]

Maybe try this macro

Please Login or Register  to view this content.

[AranDG]

Place this in your "Workbook" section in VBA, should recalculate on open, replace last paid with next due if less than todays date and replace those deu dates with a date 30 days from today (change this to suit your direct debits)

Please Login or Register  to view this content.