=A1-WEEKDAY(A1,2)+1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"uvknights" wrote in message
...
I need to take a date and convert it to a monday date.
I use the formula =today() in one cell (a1) and then in another cell(b1) I
need it to read the monday date ie: 3/3. so if today is 3/6/08 (in a1)
the
it(b1) would read 3/3/08 .. when a1 is 3/11/08 then b1 would read 3/10/08
and so on. any help would be appreicated


--
cjm