=A2-(WEEKDAY(A2)-2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DKY" wrote in message
...

How do I get excel to recognize the date of this weeks Monday? For
example. I have this bit of code, (Date - 1) for tommorow or (Date -
2) for wednesday to have it come up with August 29th, 2005. How do I
make that for this weeks Monday no matter what day of the week it is.
Monday, Tuesday, Wednesday, Thursday or Friday??


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=400172