I have a problem with the function weeknum, because the
last days in the year will be 53 and the days in the next
year will have week 1, even though they are in the same
week. I would like to do a custom function in VBA that
handles this in a correct way. Ie I would like the last
days to be 53 only when it actual is 53 weeks in a year,
otherwise I want the last days in a year to be in week 1.
I have tried to program it, but I am really struggling.
Anyone have any idea?

Thanks,

Peter