Bob

Many thanks this works really, really well!!!!!

"Bob Phillips" wrote:

Assuming the date is in A1, and the week starts on a Monday, then

=A1+CHOOSE(WEEKDAY(A1),1,0,-1,-2,-3,-4,-5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter W" wrote in message
...
I have previously been using weeknum function to produce reports in week
number order. Users now wish to see the actual start date of each week. Is
there a standard function to do this or do I need to create an algorithm?

Regards