11 Replies Latest reply on Mar 17, 2011 3:22 AM by Joe Mako

    If Relative Dates worksheet could be improved for Period over Period... Date Measures

    Dean Glasener

      Date Picker Enhancements: For Year over Year Date Calculations


      We need 4 dates:

      This  Period:  Start Date  and End Date

      Prior Period:  Start Date  and End Date


      We Need an Anchor Date:    Today()    { and a Box for  -1 }


      We Need the Comparison Period Length:  Years, Months, Weeks, Days, etc { ? exclude Todays, or this Period??}


      Common Business Lengths:  Last 21 days , Last 6 Weeks, etc


      Thanks for consideration.