Determining Quarter from a date in Excel
Excel is a great program to manipulate your data, perform what-ifs, and graphically display results. But it's not straight forward when you want to know the which Quarter certain activity took place. Fortunately, with a simple formula you can determine the Quarter.
Roundup can be a useful function in other applications as well. The last parameter (0 in this example) is used to change the rounding level. A positive number will add decimal places, while a negative number will round left of the decimal (i.e. -1 rounds to 10s and -2 rounds to 100s).
=ROUNDUP(MONTH(A1)/3,0)
![](http://2.bp.blogspot.com/_AOsG6-cAzZ0/RiLen1dKiCI/AAAAAAAABaE/tXaIM3SmbUc/s400/roundup.png)
Comments
I just wonder why Excel 2007 does not have a function to do this.