Recently I was building an Excel model that required ISO week numbers. I do have some VBA code to do that and for simpler models, I use a formula to enter directly into a worksheet cell. This time however, I required a calculated column in PowerPivot. It bugs me that the WEEKNUM function in Excel […]