WeekNum - let it work with a Array like Month() does
We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.
However
'=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
does not, because WEEKNUM can't handle an array or range.
Please give us a WEEKNUM that handles Array and ranges
Thank you.
10
votes
rvamerongen
shared this idea