Try:

=ROWS(INDEX(A1:A65535,MATCH(TRUE,A1:A65535<>"",0)):INDEX(A1:A65535,MATCH(2,1/(A1:A65535<>""))))
confirmed with CTRL+SHIFT+ENTER