Branched from this thread:export to excel
Sarthak -- I'm involved in another thread where we are collecting the filter selections and building them into the URL string. That thread is here:
In that thread we're opening as a PDF, but the principle is the same.
He shows how to build a text string of all the values selected in a filter. In the PDF thread we are working at collecting the string of dates. You may also want to consider a "Start-date" and "End-date" parameter and pass those instead.
In one workbook I use a calc field to build my URL with several parameters getting passed. This is what it looks like:
"&Period%20to%20View="+[Period to View]+
"&Fiscal%20Month="+str([Parameters].[Fiscal Month]) +
"&Retention%20Category="+[Parameters].[Retention Category] +
There are plenty of posts and white papers out there that also describe how to pass parameters and filter values on a URL string.