Ron de Bruin wrote...
Maybe in the next version of Excel?
....

Want to bet on it?

The easiest solution would be just to add a WEEKNUM.ISO worksheet
function, but I don't believe Microsoft has added any worksheet
functions since XL97 (though GETPIVOTDATA has changed since).