Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try week(addmonths(LastWorkingDate,-9))
try week(addmonths(LastWorkingDate,-9))
Thanks I think that did the trick.