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

Hello,

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

--
Kevin Smith :o)


"Francois via OfficeKB.com" wrote:

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

Kevin Smith wrote:
Hello,

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

Excellent, Thanks a lot

--
Message posted via http://www.officekb.com