Not better than Rowan's simply in answer to your question mark:

=TODAY()-WEEKDAY(TODAY(),1)+6+(WEEKDAY(TODAY())=7)*7

--
Regards,


Sandy

Replace@mailinator with @tiscali.co.uk


"Winston" wrote in
message ...

Hi All

Cannot believe how helpful you all are, thanks very much but.

we have a winner Rowen, I copy and pasted his formula and it the only
one that works so far?.

;) :)

Thanks Again All.

Winston.


--
Winston
------------------------------------------------------------------------
Winston's Profile:
http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=479278