Find gaps in stock data

I am in need of a simple macro to find gaps in stock data. I've attached a dummy workbook with further detail. Would appreciate if anyone could help. Thanks

see the result of the macro in column sV and W.
data in col S and T kept for checking. you can delete them

I am also sending back the file

the macro (already in the module of this file)

Please Login or Register  to view this content.

the data after running macro will be