Advanced Reporting Add-In Tips and Tricks
      Back to home
      1. Help Center
      2. Advanced Reporting Add-In
      3. Advanced Reporting Add-In Tips and Tricks

      Populating ARA Report Dates - Excel's "End of Month" Formula

      Excel's "End of Month" formula is a very useful function when building reports & populating dates in the Advanced Reporting Add-In.

      The function allows you to speed up the process of populating dates in your report, and allows you to make reports that are more dynamic.  With report dates built using this formula you can update all the dates in your report by updating one "starting" or "report" date.

      See the attached spreadsheet for a demonstration of how the "End of Month" formula can be used.