date of monday of each week automatically

M

mturner

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


I have the above code which gets the date for the monday of the week i
to a cell, if you open the file in that week. However I thought once i
was saved, then it would stay the same, however, it keeps gettin
overwritten. I want to get it to remain as the date it captures fo
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 manua
interference would be needed.

Thanks for any help

Mar
 
Top