The date range functionality for our Google Sheets integration is set up to accept a wide range of date formats. 

As long as you're using one of the date formats below, your widgets will change based on the date range you've set in our platform.

 

Acceptable numerical date formats

dd-mm-yyyy
For example: "26-04-2019" for April 26th, 2019

dd/mm/yyyy
For example: "26/04/2019" for April 26th, 2019

mm//dd/yyyy

For example: "04/26/2019" for April 26th, 2019

mm-yyyy
For example: "04-2019" for April, 2019

mm/yyyy
For example: "04/2019" for April, 2019

Acceptable written date formats

Written month, day, year
For example: "July 1st, 2019" or "July 1, 2019"

Written month, year
For example: "December, 2019"

Configuring Google Sheets cells as a "date" format

We recommend setting your Google Sheets cells as "date" format to ensure date range compatibility. If you're getting an invalid date format on your widget, please format your date column by selecting the column > Format > Number > Date.

 

What's Next 

Did this answer your question?