Related Posts
Anyone know what these badges are?

Additional Posts in Excel Genius
Still don't have xlookup. #fomo
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.








Yes. Create a row that is 1, +1, +1, +1, =A, =B, =C, =D and copy that all the way over.
Then a year row with similar syntax but make it 2021, =A, =B, =C, +1, =E, =F, =G.
Then in final row: =concatenate (row 1 & “Q” & row 2)
Agree, use a concat function.
Could use =edate() formula to add 3 months and then lookup to a table that says what quarter the month is in.
Consider using a table