Hi,
I am making an outgoings sheet for a business. Generally, a company will give us a statement each month and the amount will be due on the first of second month (e.g. Octobers statement is due 1st Dec) however, for one supplier (Supplier 1) it is the third month (e.g. Octobers statement is due 1st Jan).
I want to show a summary of these amounts (Next Month, Second Month and outstanding). The picture below shows the statements from each month/supplier.
Next Month, showing the sum due the following month (as it's Dec now, sum due in Jan).
Second Month, show the sum due in the second following month (as it's Dec now, sum due in Feb).
Outstanding, sum of the outstanding.
I hope I have been able to explain that well enough, I want it to automatically update.
Thanks,
Dan
I am making an outgoings sheet for a business. Generally, a company will give us a statement each month and the amount will be due on the first of second month (e.g. Octobers statement is due 1st Dec) however, for one supplier (Supplier 1) it is the third month (e.g. Octobers statement is due 1st Jan).
I want to show a summary of these amounts (Next Month, Second Month and outstanding). The picture below shows the statements from each month/supplier.
Next Month, showing the sum due the following month (as it's Dec now, sum due in Jan).
Second Month, show the sum due in the second following month (as it's Dec now, sum due in Feb).
Outstanding, sum of the outstanding.
I hope I have been able to explain that well enough, I want it to automatically update.
Thanks,
Dan
