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?

Use query, get yesterday now-1 and operate it with the year - 0 for this year and year-1 for last year — user11982798
– user11982798, Commented Jan 11, 2020 at 3:39

Michele Pisani · Accepted Answer · 2020-01-11 09:47:21Z

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

answered Jan 11, 2020 at 9:47

Michele Pisani

14.2k3 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MattKing Over a year ago

I agree with Past 14 days and Yesterday, but for same stuff for last year I would use EDATE(). Like: EDATE(TODAY()-14,-12) and EDATE(TODAY()-1,-12)

Collectives™ on Stack Overflow

Dynamic Start and End Dates Google Sheets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related