• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding Quarters

cpons

New Member
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!
 

Peter Bartholomew

Well-Known Member
= 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()
 
Top