A spreadsheet to track payment arrangements where payments hit on the 1st & 15th only. Each date is a column, each customer is a row. I've currently got a VB to enter payments collected to date - sums all black numbers - the scheduled payments are red - they are changed to black when they are received.
Is it possible to have a formula that will return the date of the most recent payment received (date column with black font for the payment - not red font).
Is it possible to have a formula that will return the date of the most recent payment received (date column with black font for the payment - not red font).
