Skillwave Training @skillwave.training · May 20 A question came up in an AKA session that is deceptively simple: "How do I get my report header to automatically reflect the month I have selected on my timeline slicer?" 📅 The challenge is that #Excel does not give you a direct way to read what a timeline or slicer is currently filtering. 🧵
2 likes 1 replies
?
Replies
@excelguru had a clever workaround: 1️⃣ Create a 2nd, hidden #PivotTable connected to the timeline 2️⃣ Configure it to return the MAX date from the filtered period 3️⃣ Give that PivotTable a meaningful name.. 4️⃣ Write a TEXT formula in your header cell that pulls from that PivotTable and formats the date