Counting the number of blank cells between a specific value

[egonzalez173]

I am looking for a way to count the number of blank cells between a specific column value - in this case the number 1, which represents a member order that was shipped on that specific date.

So in my example below, the first member would show one day between orders shipped, the second and third members would show 2 and the last would show 3 days between orders.

Any help would be appreciated.

PS - I am using Excel 2013 if that matters.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Member ID[/TD]
[TD]10/01/2019[/TD]
[TD]10/02/2019[/TD]
[TD]10/03/2019[/TD]
[TD]10/04/2019[/TD]
[TD]10/05/2019[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23456[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]45678[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Hi & welcome to MrExcel.
One way
=AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),2)-AGGREGATE(15,6,COLUMN(B2:F2)/(B2:F2<>""),1)-1