LinkBack URL
About LinkBacks
I have a lot of dates e.g. (03/01/2017 16:57). Is there a formula to find quarters? E.g. this would return Q1 2017, but another might return Q2 2017 for example?
I have a lot of dates e.g. (03/01/2017 16:57). Is there a formula to find quarters? E.g. this would return Q1 2017, but another might return Q2 2017 for example?
is that March 1 2017 or January 3 2017? Here is a formula for breaking out a month into a quarter... =IF(MONTH(B2)<4,"Q1 ",IF(MONTH(B2)<7,"Q2 ",IF(MONTH(B2)<10,"Q3 ","Q4 ")))&YEAR(B712)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I would make a table that houses all months below eachother and the quartal in the next column.
Then I would use Vlookup to get the quartal.
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.
It's Jan 3 2017.
Or:
="Q"&ROUNDUP(MONTH(A1)/3,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks