Hi,
I have a spreadsheet with daily data from the last few years. Each line represents a contract that has been signed, the term in days of the contract and the amount. Im trying to create a chart that shows how much is outstanding for a given day. The problem I have is that the contract terms overlap. eg. a contract was signed 1 Jan for 10 days for $100 and then another on 3 Jan for 15 days. I need to be able to show $200 for 5 Jan.
I tried doing it manually, but since it is going for a few years, it will take ages and theres not enough room on my spreadsheet. I can only think of 2 manual ways of doing. Horizontally, where each column is a day and i can sum up each day. or vertically, but this will involve going through each line and overwriting the cell with the new contract amounts.
Does anyone know of an efficient way of doing this?
Thanks
Bookmarks