Contractual Weeks Calculation

[August]

In the attached a contractual week starts at the first work day marked x and ends 7days later. The next contractual week starts on the next work day marked x and end 7 days later. The final contractual week can have less than 7 days. The No of contractual weeks for Harry would therefore be 3.
I have tried many variants of sumproducts/countifs/mod but cannot get a formula that works.
Does anyone have an idea how I could achieve the corrrect result in a formula

Many thanks

 

[Tetra201]

... Is there a way to use "SW", "W", "WF" and "SWF" in the code as these are the markers to denote days worked...

This can be done by modifying the IIf function in the VBA code to explicitly mention all your tags:

... IIf(cll = "SW" Or cll = "W" Or cll = "WF" Or cll = "SWF", "x", " ") ...

or to treat cells with any text in them as a worked days:

... IIf(cll <> "", "x", " ") ...

 

[August]

This can be done by modifying the IIf function in the VBA code to explicitly mention all your tags:

... IIf(cll = "SW" Or cll = "W" Or cll = "WF" Or cll = "SWF", "x", " ") ...

or to treat cells with any text in them as a worked days:

... IIf(cll <> "", "x", " ") ...

 

[August]

Thank you so much for this
I can't tell you how helpful this will be

 

[Tetra201]

You are most welcome.