Rolling Line Graph Interval Comparisons

Hi All,

So I have a problem that I'm trying to solve. I am attempting to use the attached data to produce output line graphs as a rolling 14 day comparison, 2023 vs 2024, and then also a rollling 8 week comparison, 2023 vs 2024, up until current day. I've attempted to create pivot tables to truncate data to those timeframes and chart off of them, but I'm having issues filtering to those particular timeframes and I'm not sure if there is a way to make it dynamic enough to update to the last 14 days, and or the last 8 weeks, for a 2023 vs 2024 comparison of those timeframes.

I've put both datasets, one for the "inbound" charts and one for the "leads" charts, each on their own tab in the attached, "inbound", being one and "Leads" being the other. The sheet labled "output" is where I need the linegraphs. I've attached the image of what I need on the output sheet and those two datasheets in the background in the attached workbook. I'm struggling on how to do the rolling line comparisons on those 14 day and 8 week, rolling comparisons. I appreciate any and all help!

INBOUND_LEADS.png