This formula always returns the previous Sunday (or on a Sunday that
day's date) for a date in A1

=A1+1-WEEKDAY(A1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537530