I have a spreadsheet with dates in a column. I wish to add a Quarter column and want excel to look at the date that is input in date column and label it Q1,2,3 or 4 in the quarter column.
I cannot for the life of me solve this
I have a spreadsheet with dates in a column. I wish to add a Quarter column and want excel to look at the date that is input in date column and label it Q1,2,3 or 4 in the quarter column.
I cannot for the life of me solve this
there are several options
but you get better help if you add an excel file, without confidentional information.
please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You will have to tell us which dates cover each quarter, or is it just Jan, Feb and March are Q1, and so on?
Pete
Jan feb march are quarter 4, april, may jun Q2, july aug sept Q3 and so on.
Hi,
One way
=CHOOSE(ROUNDUP(MONTH(A1)/3,0),"Q1","Q2","Q3",Q4)
Last edited by Richard Buttrey; 07-03-2013 at 05:50 AM. Reason: just seen response re Quarter definition. Update coming
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi,
I assume that was a typo and that April/May/June are Q1 (i.e. following J/F/M = Q4). Therefore:
=CHOOSE(ROUNDUP(MONTH(A1)/3,0),"Q4","Q1","Q2","Q3")
@Richard Buttrey
Q4 has to between ""
=CHOOSE(ROUNDUP(MONTH(A1)/3,0),"Q1","Q2","Q3","Q4")
Hi and thank you for your reply. I cannot attach a link or a pic of my spreadsheet due to restrictions at work. I am also a novice at excel so i am not sure what that sum means.
I envision that when finished the spreadsheet will allow the user to put the date in as it shoul and then excel will auto fill another column with which quarter it falls into. this will allow me to hide the qurter column and have a macro set up with a shortcut to 4 boxes labelled Q1,2,3 and 4. This will allow my users to easily access figures for each quarter.
Why not using pivot table to access figures for each quarter?
Hi,
This a somewhat different requirement to your original request to create a new quarter column. It would assist us greatly, not to say save us wasting our time, if you were to tell us up front exactly what you want to achieve. People who answer these posts are naturally somewhat reluctant to offer solutions if they find that the game changes half way through.
Is the year relevant? If you just want quarter number for a date in A1 try
=LOOKUP(MONTH(A1),{1,4,7,10;4,1,2,3})
Audere est facere
@danlRB80
I quote from #8.
This looks to me an non consistent range.Please Login or Register to view this content.
oktober - december would be quartal 1 !!!
Thank you all for your help sorry I sound confusing but the feedback I received from Richard Buttrey has worked great for my sheet.
Thank you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks