» Calculating the Quarter Number
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
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:
- Business Analysis with Microsoft Excel (2nd Edition)
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Yes, You Can Time the Market!
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Business Plans For Dummies®
No comments have been submitted.
