Determining what week a date falls in??? 1

[VoodooRage]

Is there any function to determine what "WEEK" in a year a date falls into? I would like to have a calculated expression that would assign a number to a date based on which week of the year it falls into.

Any help is greatly appreciated.

 

[cmmrfrds]

Check out the parameters for DatePart.

Debug.Print DatePart("ww", Now())

 

[VoodooRage]

Thanks alot, that was the ticket!