使用VBA Excel我试图计算条目之间列中的空白单元格数

I would like to determine the number of blank cells in a column between non-blank cells. I have an excel spreadsheet of the daily closing prices of a stock over the last year. Each row in excel lists the daily closing prices in chronological order. The spreadsheet lists the day I bought the stock and the day I sold the stock on the relevant row. A specific column is used to record the date. An extract of the spreadsheet is contained below.I would like to determine the number of blank c