Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Calculating the Quarter Number
Posted by - NA - on 22 March 2006 03:39 AM
|
|
Solution: To calculate the quarter number for a calendar year: Enter the formula: =INT((MONTH(A2)-1)/3)+1 | |
|
Comments (0)