Getting week number?

[jodleren]

Hi

When trying Format(Date, "/yyyy", vbMonday) I cannot see how I can get
the week number for Format?

VB should have this, shouldn't it?

WBR
Sonnich

 

[Mike H]

Try this

mMyWeek = CInt(Format(Now(), "ww"))

Mike