Dynamic quarters on chart title.

[Pomna]

Hello everyone, I need help creating dynamic quarters on a chart title. I want the chart to show 2018 Q4 and 2019 Q1.Am at a loss on how to get last quarter and quarter before last. That is, 2018 Q4 and 2019 Q1. Below is the code I have. I would appreciate your help. Thanks

date(QuarterName(Today(), -1),'Q')

[JordyWegman · Accepted solution]

Hi Ngumdo,

Use this, first one is two quarters ago, second one is last quarter.

=Year(AddMonths(Today(),-6)) & 'Q' & Ceil(Num(Month(AddMonths(Today(),-6)))/3) 
& ' Next Quarter ' & 
Year(AddMonths(Today(),-3)) & 'Q' & Ceil(Num(Month(AddMonths(Today(),-3)))/3)

Jordy

Climber 

[Pomna · Accepted solution]

Thank you so much JordyWegman. 

[JordyWegman]

Good! But think about it, because you are talking about the last and the one before that. It's July the 2nd today and that means Q3 has started. So according to your description, mine was good and you need Q1 en Q2 of 2019.

If that isn't right, then yours is just fine!

Jordy

Climber

[Pomna]

You are right. Thank you