Using Date Ranges in Functions

Many of our functions accept a date range. For example, to get the number of units sold for a SKU on Amazon across a date range:

=AMAZON_SOLDUNITS(sku,"date range")

You can input any custom date range, or use one of our handy presets.

Using a Custom Date Range

=AMAZON_SOLDUNITS(mysku123,"2022-08-02 to 2022-08-06")

which will return the number of units sold for mysku123 between August 2nd and August 6th, 2022.

If you’re looking to pull data from a single day, you can use a single date like this:


You can also simply provide a month to pull the total sales over that month:

=AMAZON_SOLDUNITS(mysku123,"June 2022")

or a year to get the total sales over that year:


Using a Preset Date Range

We also have some handy preset date ranges:

mtdMonth to Date=AMAZON_SOLDUNITS(mysku,”mtd”)
ytdYear to Date=AMAZON_SOLDUNITS(mysku,”ytd”)
t7Trailing 7 Days (8 days ago, through yesterday)=AMAZON_SOLDUNITS(mysku,”t7″)
t30Trailing 30 Days (8 days ago, through yesterday)=AMAZON_SOLDUNITS(mysku,”t30″)
t60Trailing 60 Days (61 days ago, through yesterday)=AMAZON_SOLDUNITS(mysku,”t60″)
t90Trailing 90 Days (91 days ago, through yesterday)=AMAZON_SOLDUNITS(mysku,”t90″)
last monthLast Month=AMAZON_SOLDUNITS(mysku,”last month”)

Have a suggestion for another preset? Let us know at