C cpons New Member Mar 23, 2021 #1 I am trying to do a formula that will add quarters for a heading to a section. Q1-2020 Q2-2020 Q3-2020 Q4-2020 Q1-2021 Q2-2021 Thank you for your help!
I am trying to do a formula that will add quarters for a heading to a section. Q1-2020 Q2-2020 Q3-2020 Q4-2020 Q1-2021 Q2-2021 Thank you for your help!
P Peter Bartholomew Well-Known Member Mar 23, 2021 #2 = CONCATENATE("Q", 1+MOD(k,4), "-", 2020+QUOTIENT(k,4)) where 'k' are integers starting with 0. For me that requires 'k' to refer to = SEQUENCE(100, ,0) but with older versions of Excel it is possible to do things with ROW()
= CONCATENATE("Q", 1+MOD(k,4), "-", 2020+QUOTIENT(k,4)) where 'k' are integers starting with 0. For me that requires 'k' to refer to = SEQUENCE(100, ,0) but with older versions of Excel it is possible to do things with ROW()
