Hello,
I am trying to create a custom function that tells me
which week of the year a certain date falls into.
I came up with the following:

Function WeekNumber(Weeks) As Integer
WeekNumber = DateDiff("ww", "1/1", Weeks)
End Function

For some reason, the result displayed is one week short,
e.g. if today's date is 7-Jul-03 then the above function
returns 27, although 7-Jul-03 falls into week 28.

The built-in Excel function Datedif does not seem to work
in VBA.

Any suggestions, solutions are greatly appreciated.
TIA.
BR, Antje Crawford