VBA To return week number?

Re: VBA To return week number?

Quote from Grasshoppa

hi all,

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?

Regards

Grasshoppa
:thanx:

Display More

Same as WEEKNUM function, not ISO?

=1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/7)

Re: VBA To return week number?

Quote from Grasshoppa

Is there a typo in that post?

VBA kicks it out as "expected )".
I'm not familar with these expressions!!!!!!!!

:thanx: anyhow.

Worked fine for me. Maybe there was a pasting error!!!!!!!!!!!!!!!!!!

Re: VBA To return week number?

Bob's solution works OK, but it's a formula not VBA, which is what Grasshoppa was looking for.

Re: VBA To return week number?

Quote from royUK

Bob's solution works OK, but it's a formula not VBA, which is what Grasshoppa was looking for.

Ah so, Grasshoppa which is why pasting the Excel formula into VBA wouldn't work.

Guess that old saying, "two wrongs don't make a right" is true. Nice link though.

Re: VBA To return week number?

Simply

Format(Date, "ww")

Re: VBA To return week number?

Quote from vaasha;641275

Simply

Format(Date, "ww")

So simple Thank you vaasha