An alternative

=A1-WEEKDAY(A1,3)+7


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111