• 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.

Dynamically picks earliest date (in quarter)

Khalil Lakhani

New Member
Hello Everyone!
I am converting date column to quarter output. On another sheet, I have a strat that should automatically picks earliest of quarters from the above list.
Attached is the spreadsheet that visually explains - Essentially, I need a formula that can pick earliest of quarters from a column -

Thanks in advance -
Khalil
 

Attachments

  • Quarter example.xlsx
    13.4 KB · Views: 4
It works - thanks! Now if I have to add 1 quarter to the subsequent rows - like on cell D10 and onwards - how do I do that?
Maybe……

upload_2017-6-21_2-3-34.png

1] D9 :

=INDEX(L8:L100,MATCH(AGGREGATE(5,6,K8:K100),K8:K100,0))

2] D10, copy down :

=LEFT(D9,4)+(RIGHT(D9)="4")&"-Q"&MID(2341,RIGHT(D9),1)

Regards
Bosco
 

Attachments

  • Quarter example(1).xlsx
    13.9 KB · Views: 2
Last edited:
Back
Top