Hi Jules

I guess some of these mails are "crossing in the post".
I sent a further response to you saying I had misinterpreted your
requirement. The formula you posted gives week number. You want the date for
the beginning of the week containing your date in A1.

Ron Rosenfeld posted
=A1-WEEKDAY(A1)+1
will give the starting date of the week. Format as a date.

and has since posted
And a more general formula would be:

=A1+1-WEEKDAY(A1+8-DOW)

Where DOW = Day of Week (Sun=1; Mon=2; etc)


--ron

I hope you pick up this mail (or the others) and sort your problem.

Regards

Roger Govier


JulesM wrote:
Thanks for ther reply Roger

I'm still not getting it to work. Sorry! Obviously I'm doing something
wrong.

If I format A1 with just general format. How then should I enter the
date? I tried 28/09/05 which still returned a value of 39.

Would appreciate any assistance...thanks again.
Jules