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

How to set year against quarter?

R

rohitabi

New Member
Hi,


In our organisation, dates between 1-Oct-11 to 31-Dec-11 is considered as Q1 of 2012.


I have fetch the quarter by applying =CHOOSE(MATCH(MONTH(A2),{1,4,7,10}),"Q2","Q3","Q4","Q1")


But dont know how to enter year in its respective column. Please help.


Regards


Rohit
 
Hi rohitabi,


Welcome to the forum, with your formula to extract the quarter in C2, apply this to extract the year


=IF(C2="Q1",YEAR(A2),YEAR(A2))
 
You must log in or register to reply here.
Back
Top