date of monday of each week automatically
 

Code:
--------------------
=TODAY()-WEEKDAY(TODAY())
--------------------


I have the above code which gets the date for the monday of the week in
to a cell, if you open the file in that week. However I thought once it
was saved, then it would stay the same, however, it keeps getting
overwritten. I want to get it to remain as the date it captures for
that week.

The only idea i can think of is :
1.Create the date using vba.
2.Make a button to insert it when creating the document.

Is this the quickest, easiest way? I was hoping that no manual
interference would be needed.

Thanks for any help

Mark


--
mturner
------------------------------------------------------------------------
mturner's Profile: http://www.excelforum.com/member.php...o&userid=30147
View this thread: http://www.excelforum.com/showthread...hreadid=498328