I have this file and need to count the continuous date value (=1)
I already made for each month but cannot make for several months.
Now I need to help: how to make formula for B70 have the result as the same B71
this file is generated automatically from an old software, and this sheet is very big and complicate with multi-cell, multi-table... Hence, it really hard to delete the gap as you can see because the tables are placed alternately

I just need: much better if there is a way can be inserted or combine into the old formula a small formulas to be able to remove the character is not 0 or 1

https://www.dropbox.com/s/nuv9eqfnmrnvlft/Caculation%20the%20continuous%20date%20value.xlsx

Thank you