how to Convert date into Week number

[DavidWRouse]

From a date i want to caluculate what week of the year it is

i.e 7 apr 03 = week 15

I cannot find a function to obtain this, Does anybody know of one, or of an easy way to program my own function

 

[Mile-O]

=Format(MyDate, "ww")

 

[Mile-O]

=CInt(Format(MyDate, "ww"))

if you want to convert it back to a number

 

[Michelangelo]

And what about changing it back to a date

so something like

date = function(weeknr,weekday)