Excel (VBA) Week Number Formula
Have you ever wondered why `WorksheetFunction.WeekNum(Now, vbMonday)` works, while in order to get the correct value for Tuesday, you have to provide this - `WorksheetFunction.WeekNum(Now, 12)`?
And if you write `"WorksheetFunction.WeekNum(Now, vbTuesday)`, you would get an error?
In this rather short video, I am explaining the basics of the `weeknum()` formula and its parameters. I hope you would get the idea.