Weeknum Function

[Guest]

Hi

I have two dates, in two columns. One is a start date, and one is a
completion date. What I would like to do is list all of the week numbers that
are included in the range between these two. So for example, if my start date
is 1 January 2005 and my completion date is 21 January 2005, I would like to
display 1, 2, 3.

Is this at all possible?

Many thanks to anyone who can help.

 

[Guest]

Hi

I don't have atpvbaen.xls as an option in my References, they all seem to be
Type Libraries. I pasted the function anyway, but it didn't work. I got the
error message: Sub or Function not defined.

Thanks

Anita

 

[Guest]

OK

I managed to find it and add it, but now it comes up with my favourite #VALUE!

Any ideas what I'm doing wrong?

Thanks

Anita