I am trying to get a formula that will, if I enter a date, show me the date
for the previous Monday.

Eg I enter 12 Sept 2009 The formula shows the date of the previous
Monday (10 Sept 2009).

The keyed date could be any day of the week, but I always want the result to
be Mondays date.

Many thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1