ExcelBanter - Getting week number?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Getting week number? (https://www.excelbanter.com/excel-programming/418233-getting-week-number.html)

jodleren

Getting week number?

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

Getting week number?

Try this

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

Mike

"jodleren" wrote:

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

All times are GMT +1. The time now is 02:59 AM.