Right, here is what i want to do.
Ive currently got a excel sheet that details all the invoices ive sent out and their status. Each invoice occupies one row. I need to add a column that details how overdue a particular invoice is overdue. If its overdue, that is.
I presume the way to do it is to compare today’s date and the date given in the ‘pay by date’ column and then detail the difference in the new column. I also need the new column to show the number of days overdue in red, but show nothing if the invoice has been paid (possibly by setting the text color to white ?). There is also a column devoted to the status of the invoice which will show ‘invoiced’ if unpaid and ‘paid’ if already paid.
I guess i need a formulae to sort all this out, but im pulling my hair out trying to do it
Can you help ??
