This content has been marked as final. Show 2 replies
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.