Excel (VBA) Week Number Formula

Опубликовано: 17 Январь 2025
на канале: VitoshAcademy
378
2

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.