Hi,
I am doing a statement of account excel sheet for a friend of mine. Basically all pending invoices will be inserted in this sheet by date issued and also their corresponding amount.
Apart from the total (which I know how to do), at the bottom of the statement I would like to add a total amount outstanding for 30 days and the same for 60 and 90 days.
Anyone has an idea how to do this?
Thanks
Bookmarks