1 Reply Latest reply on Jul 23, 2014 1:10 PM by Ben Neville

    Is it possible to have a calculated dynamic YTD Anchor?

    Caryn Hefferren

      I have a several workbooks that I update monthly, and each month have to change the YTD anchor date in multiple locations which is somewhat time consuming.



      Is it possible to have a calculated field that would query YTD and dynamically set the anchor for the last day of the previous month?

      If so I would greatly appreciate some insight or an example on how to accomplish this.


      Thank you!