Careful - this returns an erroneous date if the user is using the 1904
Date system.

Better: =A1+1-WEEKDAY(A1,2)

In article ,
Teethless mama wrote:

=A1-MOD(A1-2,7)

"Matt Sharman" wrote:

Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the
preceding
Monday?
thanks Matt