Auto formula update on a date

[rutterc85]

ive set up an expenditure worksheet, part of which includes outstanding debt. Is there a way where either every month on a set date the outstanding debts will reduce or when I input my income on payday the outstanding debts will auto update rather than me having to manually deduct the debt repayments from them?

Many thanks

[#2]

@rutterc85 You can simply create a separate column for income/collection and put a formula to deduct the from Outstanding Amount. Simple Deduction formula can be used to get the latest data of Outstanding.