I have a new problem that needs another upgrade. I will try and describe what they want me to do.
Column A is the date of invoice
Column B is the invoice amount
Column C is the amount paid
Column D is the accounts receivables
Column E is a 30 letter
Column F is the 45 day letter
Column G is the 60 day letter
Column H is the 75 day letter
Column I is the write off date

The first step is the easiest in that there is a formula in D (b-c)
Using the current date minus the invoice date I need to generate a formula in E where if it is >30 and <45 and D does not equal to 0 give me a date. This formula will then copied to column F using if>45 and <60 and D is not 0, G using if >60 and <75 and D is not 0, H using if >75 and D is not 0. But while this is happening there can be only one date showing from columns E to H. I hope I haven't confused you too much. If you could help please and thanks.
tried to modify this formula
=IF(or(A2="",d2=""),"",IF(ISNUMBER(R200),DATE( YEAR(R200),M ONTH(R200),DAY(R200))+30,"")) by adding 45 days etc., but that doesn't remove the first instance of E when F comes up to 45 days.

Regards g-c