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
Can someone help for this file, thanks you.
View attachment Caculation the continuous date value.xlsx
Sorry for my bad explain
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
Can someone help for this file, thanks you.
View attachment Caculation the continuous date value.xlsx
Sorry for my bad explain