Hello,
can you pls explain something to me? I am using formula
where in A1:A5 is date 01/01/2018. Formula is working fine, in Excel 2007+ Weeknum can handle array by adding +0. I am just wondering, whats happening behind, that this same formula does not work without ,,+0". If I evaluate part
, I get 5 x True, which by using double minus gives me desired 5x correct weeknum (which is 1 in this case) and sumproduct works...But if I evaluate that part without +0, I get VALUE error. Can you pls explain to me, what is causing adding zero in this case?
Thank you in advance for all answers. I am just trying to understand it correctly.
Regards,
Tom
can you pls explain something to me? I am using formula
Code:
=SUMPRODUCT(--(WEEKNUM(A1:A5+0,21)=1))
Code:
WEEKNUM(A1:A5+0,21)=1
Thank you in advance for all answers. I am just trying to understand it correctly.
Regards,
Tom