Chris,

Not as simple as it at first sounds. Check out this previous post from
Norman Harker, it gives good detail

http://tinyurl.com/2xlg5


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or
calculator?

Chris