» Calculating the Quarter Number
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
To calculate the quarter number for a calendar year:Enter the formula:
=INT((MONTH(A2)-1)/3)+1
To calculate the quarter number for a fiscal year ending in September:
Enter the formula:
=MOD(CEILING(22+MONTH(A2)-9-1,3)/3,4)+1
Note: The number 9 in the formula represents the number of the last month of the fiscal year (September).
Book Store:
Recommended Books:
- Dictionary of Finance and Investment Terms
- The Guide to Understanding Financial Statements
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
