Hello,
I need a formula to return the countif based on the current work week (starting on a Monday).
My data looks like this:
<tbody>
</tbody>
The formula in B1 must check if a date in A4:A11 is in the current work week and if it is, then display the count of "Y" in the corresponding columns.
In this case, there are 3 "Y" in the current work week (30.07 - 05.08) in row B, therefore B1 is 3.
Thanks in advance!
Owen
I need a formula to return the countif based on the current work week (starting on a Monday).
My data looks like this:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||
3 | 6 | Y | Y | Y | Y | Y | Y | ||||||||||||||
3 | 6 | Y | Y | Y | Y | Y | Y | ||||||||||||||
2 | 5 | Y | Y | Y | Y |
<tbody>
</tbody>
The formula in B1 must check if a date in A4:A11 is in the current work week and if it is, then display the count of "Y" in the corresponding columns.
In this case, there are 3 "Y" in the current work week (30.07 - 05.08) in row B, therefore B1 is 3.
Thanks in advance!
Owen