I am modifying a customer invoice tracking spreadsheet in EXCEL so that all invoices for the year are already set up with invoice date in one column and the due date the next column. I have a running balance set in the final column to using SUM to calculate the payments/invoices and OFFSET to create the running balance for the account. =SUM(H11,-G11,-F11,OFFSET(J11,-1,0))
- How can I create a formula to show TODAY's balance on a separate line so that the customer can see their current balance at a glance, rather than the balance for the whole year? I originally wanted something that said "If TODAY is greater than the date in Column B, show the corresponding value in Column J" but don't know how to code that.
Thank you so much for your help.
Bookmarks