This Analytics Edge wizard lets you select the date range to be used for the query.
You can pick from several preset values, or pick a combination of start date, duration and/or end date.
Note that some metrics are not available for several days.
For the dates, you can select a specific calendar date, pick from one of several dynamic dates like ‘start of last month’, or enter a date value.
When entering a date manually, you can type in the date, use an Analytics Edge range name (like [Date]), or enter a cell reference to a worksheet containing a date.
Finally, you can select to use the date range chosen, or use the same duration period previous to the chosen date range, or use the same period from the previous year.