the OP only wanted Monday if the date was a sat or sun not next monday in all
instances

"oldchippy" wrote:


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