
Re: Excel - Custom WEEKNUM function (fix for 2010)
Here is the code.
Inserting this function into a module of your excel workbook will have priority over the builtin one.
Code:
Function Weeknum(str, Optional num As Variant)
If IsMissing(num) Then num = 2
Weeknum = DatePart("ww", str, 2, num)
End Function