» 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:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Marketing Management
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Investing for Dummies, Third Edition
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
