Dynamic Start and End Dates Google Sheets

Question

I'm trying to create a dynamic dashboard in google sheets with the google analytics add-on. I'm having trouble figuring out how to make the start and end dates dynamic. I would like to look at

• Start Date: Past 14 days
• End Date: yesterday

and then also run the same report for

• Start Date: Past 14 days last year
• End Date: yesterday last year

how can I come up with these start dates?

Answer 1

You can use simply TODAY fomula and subtract the number of days you want.

In the case of your example:

=TODAY()-14
Start Date: 28/12/2019

=TODAY()-1
End Date: 10/01/2020


=TODAY()-379
Start Date: 28/12/2018

=TODAY()-366
End Date: 10/01/2019