Get date details from Timeline

[Ucubia]

Hi,

I have built a scrolling timeline to select a month, but I would like to get month that has been selected to incorporate into another formula - is there a way to do this?

Would appreciate any advise.

Many thanks

Ian

 

[lrobbo314]

This should get you started. You can get a start and end date from the timeline with the code below. You may need to change the name of the slice cache in your code.

Sub Timeline()
Dim s As SlicerCache: Set s = ActiveWorkbook.SlicerCaches("NativeTimeline_Date")


Debug.Print s.TimelineState.StartDate
Debug.Print s.TimelineState.EndDate


End Sub

 

[Ucubia]

Thank you for this - I will see if I can adapt it to get to where I need to be.

I was hoping for an Excel function something akin to Getpivotdata in order to extract the information I need but that doesn't seem to be possible

Will have a go.

Thanks again

 

[mgoutier]

I am also in the same boat where I need to use start and end dates from a timeline in some formulas. I can't seem to get the above code to work. It could be my very basic understanding of VBA. Any chance you have a working workbook you could share so I can analyze?

 

[kcmuppet]

I did it this way to avoid having to use any VBA:

Excel: Creating Tables from Timeline Slicers - Strategic Finance

Use a disconnected pivot table to generate a worksheet title that always shows the dates selected for a Timeline slicer.

sfmagazine.com

(Create a second copy of the pivot table; then make the 2nd pivot table display only the min and max dates from the dates field and use those in your formulae)