Same as WEEKNUM function, not ISO?Originally Posted by Grasshoppa
Has anyone any idea how to get VBA to give the current week number?
I know i can use the analysis toolpak in excel but i need this form I'm creating to give me the correct week number even if the analysis toolpak isn't installed on a machine. does anyone know of a workaround?
Bob's solution works OK, but it's a formula not VBA, which is what Grasshoppa was looking for.
There are currently 3 users browsing this thread. (0 members and 3 guests)