Assist with WEEKDAY formula (or similar)

[Francois via OfficeKB.com]

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.

 

[Kevin Smith]

Hello,

if the date was in cell G1 then this would return the previous Monday.
=(G11)-(WEEKDAY(G11,3))

 

[Francois via OfficeKB.com]

Hello,

if the date was in cell G1 then this would return the previous Monday.
=(G11)-(WEEKDAY(G11,3))

Excellent, Thanks a lot