Week Number

[Guest]

What I have done I pasted ISO week & ISO year start script into modules &
after that I saved that file. After opening the same file have entered some
dates into excel but it is not giving me week number.

Can you please guide me how to do it as I am not the VB script expert.

Can you also let me know is that possible that I can get week number in
desired column number.

Appreciate your help.

Kam.

 

[Guest]

Assume date is in A1:

in B1:

=isoweeknum(a1)

B1 will contain the week number for date in A1

HTH

 

[Guest]

An easyway is to just add your week number to the system week number (or
subtract) with a function like =WEEKNUM(A1,1)