Does this work for you?

=IF(WEEKDAY(A1,2)1,A1-(WEEKDAY(A1,2)-1)+7,A1)

The "=A1 - (WEEKDAY(A1, 2) - 1)" bit, returns the Monday prior to any
given day in Cell A1, and they you add seven to it.


--
TBee
------------------------------------------------------------------------
TBee's Profile: http://www.excelforum.com/member.php...fo&userid=3557
View this thread: http://www.excelforum.com/showthread...hreadid=455835