Create Function To Change Date into Week Number

Hi All,

Im trying to save myself some time and create loads of new functions in my Perosnal macro workbook.

At the moment i'm trying to create a function that converts a given date into its corresponding week number.

i know the formula to do this is as follows:

Please Login or Register  to view this content.

Where A1 = the cell reference that contains the date.

Obviously my function would start as follows:

Please Login or Register  to view this content.

I'm just not sure on how to work the formula into this function?

Please help

thanks for reading my thread everyone