Dear!
Please help me write formula to get the value as in the selected cells based on the data set in the table on the left.
Thanks!
What is need is the number of months that the customer hasn't paid after his/her last payment.
For example: Customer-A hasn't made payment from Jan till Oct, so the number of unpaid months should be 10 months. On the other hand, from the same period (Jan-Oct), Customer-A did not pay in Jan, Feb, Mar, Apr, and in May he/she paid. Then from June till October, he/she hasn't made payment again. In this case, the unpaid months should be 5.
What you ask and what you attach is very different. Your attachment only ask for invoice not paid.
Hi Mey,
Please use topic subjects that disclose something about the topic. 'Ask for help' doesn't help us or others identify if this topic is something they are experienced with and can help on, or interested in.
Thanks,
Mynda
