Hi everyone, I am trying to create a spreadsheet to monitor cashflow but it is not as easy as I thought. Using XP pro and Excel. 1st column is the date of an invoice. 2nd column is the ammount. 3rd column is the date paid. 4th column is how long it took to be paid in days. 5th column is to show invoices outstanding and how many days. This needs to be time related ie add a day every day unless it can be configured to the clock. If that is not hard enough for you then I would also like all previous paid invoices that took longer than 30 days to show in red and all outstanding invoices over 30 days to show in red.
Thanks rossgolf, yes it will need conditional formating, a bit complicated for me hence the posting also tying up the dates to work out the outstanding days is not easy for me. vog has helped me a lot in the past with similar things he seems to be the Excel guy, hope he comes on the site and can help but I am not biased I will take help from anyone that knows more than me and I am sure that there are plenty.