Preselect a date on opening a document

[simongoodman]

I want the document on opening to select the last data working week. I know about Document Properties/Triggers/Document Event Trigger/OnOpenHasAction. So for example for Oct to Sep as the financial year if the last working date is 16/11/2012 then the working week should be 7.

My problem is I have target data till 30/09/2013, so =maxstring(week) would return week 52. I have tried a number of ideas unsucessfully including a version of =Weektoday().

Please can someone point me in the right direction. The script is attached.

[Gysbert_Wassenaar · Accepted solution]

try week(addmonths(LastWorkingDate,-9))

[simongoodman]

Thanks I think that did the trick.