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

(137 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion