Changing Date in web query

Stephen Smorol
New Contributor

Changing Date in web query

How can I automatically change the date or enter a date in a cell to change where the web query gets the data table from? I also have a question on how you can do a date range? The dates are at the end of the url, and the ones with a range have the dates inside the url as well.

Some of the queries I want are for 14 days, 30 days, etc. 

Here are a couple examples. 

It seems some of the 14 day ones use actual dates and some may be based on the current date (9/26/17) in this example. 

Thanks in advance if you can help!





Thanks in advance!

2 Replies

Re: Changing Date in web query

Re: Changing Date in web query

That doesn't work the way I want...I think I need to use power query

Related Conversations
FindTime becomes Find a time in Office 365
Darrell Webster in Change Alerts on
79 Replies
Events from Email now showing up in Calendars
David Margossian in Change Alerts on
13 Replies
New Features - Messagecenter and Roadmap differs
Florian Lutz in Change Alerts on
7 Replies
Office 365 - Meltdown and Spectre CPU bugs
Cian Allner in Office 365 on
0 Replies
Don't upgrade to iOS 11 if using the native email app
Cian Allner in Change Alerts on
7 Replies
New Office 365 ProPlus Update Channel Names
Cian Allner in Office 365 ProPlus on
1 Replies