- Analytics Tools Guide
- Analytics Release Notes
- Get started with Adobe Analytics
- Landing page
- Analysis Workspace
- Analysis Workspace overview
- Projects
- Reports
- Templates
- Components
- Visualizations
- Visualizations overview
- Manage data sources
- Freeform table
- Cohort Table
- Fallout
- Flow
- Area and area stacked
- Bar and bar stacked
- Bullet graph
- Combo chart
- Donut
- Histogram
- Horizontal Bar and Horizontal Bar Stacked
- Key metric summary
- Line
- Map
- Scatterplot
- Section header
- Summary Number and Summary Change
- Text
- Tree map
- Venn
- Panels
- Curate, Share, and Schedule projects
- Attribution
- Journey IQ
- Segment IQ
- Anomaly Detection
- User preferences
- Workspace FAQs
- Report Builder
- Legacy Report Builder
- Legacy Adobe Report Builder help
- Legacy Report Builder setup
- Report Builder toolbar
- Data requests
- Data requests - Request Wizard Step 1
- Create a data request
- Report suites
- Manage segments
- Report types
- Import bookmarked reports and dashboard reportlets
- Date ranges
- Interactive controls
- Layout - Request Wizard Step 2
- Layout overview
- Metrics and dimensions
- Anomaly Detection
- Configure an anomaly detection request
- Format the date
- Format display headers
- Hide or show headers
- Delete output mapping
- Name a request
- Prepend and postpend text to cells
- Configure the custom layout
- Map metrics and dimensions to cells
- Create a microchart
- Filter dimensions
- Manage requests
- Manage requests - definitions
- Diagnostic messages
- Sort ascending or descending
- Protected worksheet elements
- Edit multiple requests
- Edit metrics across multiple requests
- Refresh a request
- Refresh requests for all sheets
- Add dependent requests
- Classification
- Copy requests
- Save a workbook with requests
- Specify conditional formatting
- Offline mode for creating and editing requests
- Report Builder options
- Schedule report requests
- Schedule a workbook
- Scheduled Task Manager
- Workbook Library
- Publish to Power BI with Report Builder 5.5
- Visual Basic macros
- Report Builder troubleshooting
- Report Builder FAQ
- Activity Map
- Adobe Analytics dashboards
- Labs
Dates from a cell
A new and streamlined Report Builder was released on October 16, 2024. It is supported on Mac, Windows, and web browsers.
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.
You can specify a date range by selecting cells from a worksheet that contains a request. Report builder uses the specific date range information in those requests. If you select today’s date, you see partial data based on the time of day the request runs.
To configure dates from a cell
-
On the Request Wizard: Step 1, select Dates From Cell.
-
Enter cell references in the From and To fields, or click the selector and select the cells containing the requests with the starting and ending dates.
For example, create a Report Builder request with the date range set to “yesterday” and output the request date in the same cell as “today()-1”.
Here is a list of supported date formats:
