Posts Tagged ‘xcelsius’
Excel – Quarter/Year from Date
February 23, 2011
Leave a comment
So you want to display the Quarter Number, Q1,Q2 etc along with the Year in the format Q1-11 Q2-10 etc.
This is a handy formula which will allow you to group all your dates in the relevant quarter of the year.
I found this particularly useful for an Xcelsius dashboard, which needed to group and filters data into Quarters.
Enter your date field in A1 and place the forumla below in the require cell.
=”Q”&INT((MONTH(A1)-1)/3)+1&”-“&RIGHT(YEAR(A1),2)
1/1/2011 Q1-11