Use the date part function

DatePart(Interval, Date

DatePart("ww",date) will produce the week number
--
Kevin Backmann


"vba_kraker" wrote:

How to get a proper weeknum function in vba working?
I'm familiar with the weeknum function in the ordinary worksheet, but in vba
it's a different story.
Has anyone suggestions how to generate the weeknumber by the means of a
function in vba?

Many thanks in advance.