Count number of empty columns in a row since non-empty column

Hello everyone,

I am trying to figure this out a formula in order to count the number of empty columns in a row since a non-empty column.

The idea is to get a number of inactive months since the last entry. I have included an excel showing what I am trying to achieve.

I have tried using some of the formulas that I have found in this forum and in other places with no luck.

Any help is greatly appreciated.

Thanks!

Here's a non-array alternative:

T2 =COUNTA(B$1:R$1)-IFNA(LOOKUP(2,1/(B2:R2<>""),COLUMN(B2:R2))-1,0)

I really apprecite both of your answers. For some reason, the first one didnt work for me but the second one worked well. Much appreciated!

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.