Menu
Is it possible to change the cell format to display quarter and year q yyyy instead of dd-mm-yyyy?
946
Use the formula =QUARTILE (array, 1) in an empty box to calculate all quartiles in Excel at once. You can replace the array with a cell reference of the dataset. Moreover, number one represents Q1. You can write “2” to determine Q2, “3” to find Q3, and “4” to calculate Q4.
To get quarter from a date, you simply need to divide the month by 3 and round up the result to the nearest integer. Since each quarter of the year consists of 3 months, dividing the month of a date by 3 returns the number of 3-month intervals.
No - quarters are not a customisable format
The closest I think you could get would be to use a formula which has two potential limitations
=INDEX({"Mar","Jun","Sep","Dec"},ROUNDUP(MONTH(A1)/3,0))&TEXT(A1," yyyy")
will return the quarter (based on a calendar year) and year of a date in A1, i.e. for today's date Dec 2011
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
