Sep 1, 2026 · 9 min · 7 segments
Can you make Excel reporting more interactive? Yes, you can. And it's all to do with dynamic arrays. In the second of this two-part series, discover how to create dynamic Excel charts this time…
Okay, so let's look at how we
So the idea is that we use the year function in Excel, which gives us the calendar year, but we can sort of hack that function by adding 184 to the date and then getting the year of that adjusted date.
And the reason is there is 184 days between the 31st of December and the 30th of June.
You just add 184 to the date, get the year of the adjusted date, and then you are working with the financial year rather than the calendar year.
Because in the chart selection, you had the ability to select a year, which in part one was only working with the calendar year.
But in part two, you'll see that that will now work with the financial year rather than the calendar year.
Okay, so let's look at how we
So the idea is that we use the year function in Excel, which gives us the calendar year, but we can sort of hack that function by adding 184 to the date and then getting the year of that adjusted date.
And the reason is there is 184 days between the 31st of December and the 30th of June.
You just add 184 to the date, get the year of the adjusted date, and then you are working with the financial year rather than the calendar year.
Because in the chart selection, you had the ability to select a year, which in part one was only working with the calendar year.
But in part two, you'll see that that will now work with the financial year rather than the calendar year.
The rest of this transcript — segmented and speaker-labeled, so you land on the exact moment something was said
Search every transcript — by keyword, by phrase, or by meaning, across every show Radar indexes
Trends — what is surging across podcasts, measured against its own baseline
Alerts — when a name you follow appears in a newly indexed episode
No account is needed to search Radar.