IF with dates and conditions

Hi ! yes sorry I guess I got confused here is what I work with (unless I didn't managed to attach it properly)

oh you are right..... I have Version 2111 Build 16.0.14701.20206

D Is number of day after Invoice is made, until it's considered unpaid (so 1st reminder needed)
E Is number of day after 1st reminder, until we have no answer, so the first remider deadline is passed we need to send a 2nd one
F is number of day with no answers and the client is now "Contentious"

Row 1 = Titles
Row 2 = Invoice over 60 days old(red); 1st reminder less than 30 days old(green) : we need to wait for the answer/payment
Row 3 = Invoice over 60 days old(red); 1st reminder more than 30 days old(red); 2nd reminder more than 15 days old(red); Client will be classified as "contentious"
Row 4 = Invoice payment is overdue; but not enough time to justify a reminder(60 days); (yellow) : we are still awaiting for the payment (even if it's currently late)
Row 5 = Invoice payment isn't late yet(green) ; we are waiting for the payment
Row 6 = Invoice over 60 days old(red); 1st reminder more than 30 days old(red); 2nd reminder less than 15 days old(green); we are waiting for an answer/payment
Row 7 = Invoice over 60 days old(red); 1st reminder more than 30 days old(red); the 2nd reminder has not be sent (cell empty) : we need to send a 2nd reminder to the client.

I hope this can clear it a bit
I'm sorry if it's confusing I'm not used to make stuff like this

Thank you for your help.

I should have removed the Client code column, use the invoice as a client number.
I don't have many clients on the datasheet for now since I don't have access to the database during week ends. I do not care for the clients codes for now

I'm sorry I can't generate better data; because it's sadly the data I have to work with.
We are a virtual company for training, and so are our clients. The average trainee will stay between 4 month and 6 month there.
With the Sanitary situation we could not get access to the invoices from two years ago, neither could our clients.
We are the first back and have to sort this all out.

Yes some invoices are over two years olds, but the client is probably not aware it even exists, since the trainees were not there.
So if we see a two year old invoice, we need to send a reminder to pay, as we notice it, and the people there also need time to sort it out.
That's why we have 2years old invoice, only reminded now to our clients.
We more or less randomly choose 60 days to sent reminders so we can begin to sort for ourselves, what doesn't need to be touched yet, given we have 2 years to catch up.
So maybe it was not the right choice to highlight the date as I did but I don't personally see what a new column would bring, that a quick Today()-(numbers of days) or Invoice date + (number of days) could not.

I wanted to do this to easily follow in the first column so me and my colleagues rapidly see what we have to do.
They are even less knowledgeable on excel that I am, I don't want them to have to deal with many columns if I can prevent it

My logic was

If the invoice is less than 2 month old I want to cell to read "Wait for answer/payment"
If it's more than 2 month old; check if the 1st reminder was sent (if the cell is empty it's has not) ; if it's not sent I want the cell to read "Send 1st reminder"
If it's sent, has it been less than a month ; if so, the cell reads "Wait for answer/payment (1st reminder)"
If it's more than a month; was the 2nd reminder sent (same as before, if it's empty, it was not sent); if it wasn't sent "Send 2nd reminder"
If this has been less than two weeks "Wait for answer/payment (2nd reminder)"
if it's been more than two weeks, the client is known as contentious for that invoice(except, we can't cut ties with clients, since all of this is for learning purposes; there are no concequences if they don't pay)

All of this aside; Is it possible to have that many conditions ?
Thank you all for trying to help I really appreciate it

I managed to do what I wanted I needed to use IFS and not many IF

Please Login or Register  to view this content.

Thank you to everyone that tried to help