Extracting Cancelled Order Month

I need to write a formula that will identify which month a customer stops business with us. Attached is a sample of data. I have a match formula which look across a row and identifies if revenue is NIL and give me the month this occurs. The problem arises when I have no revenue at the beginning of the year and then a customer delivers revenue later. In this catch the match formula give a cancel month as Jan. Also if as in Row 3 of the attached I have revenue for a few months, miss some months and then finally stop business in September. The current formula states that business relationship ended in May but in fact does not end until Sept.

Thanks for any help

Mike

Thank you Pepe. This appears to do the job very nicely

Best regards,

Mike

I am still encountering problems with the live file. The live spreadsheet data starts at column T and when I add the formula it fails to work. Also if I have sales in December I do not want a month stated as this is not a lost customer so it can left blank or state something like "Continued Customer". I have attached a revised version of the spreadsheet.

Thank you again Pepe. So if I simply deduct the number of columns to the left of the first column it will give me the desired answer?