In this article we will learn how to calculate the quarter number for Fiscal Year and Calendar Year in Microsoft Excel.
To calculate quarter in Excel you can use the formula of “INT”, “MONTH”, “MOD” and “CEILING” function.
INT function is used to return the whole number without decimals. This is better than changing the number of decimal places displayed, which would risk some numbers being rounded up and thus giving an incorrect result.
MOD function is used to returns the remainder after a number is divided by a divisor.
MONTH function is used to return the month in numbers.
CEILING function is used to roundup the number to the nearest multiple of a specified value.
Let’s take an example and understand how to calculate the quarter number.
We have a table of dates, in which we want to return the quarter according to the calendar year and fiscal year.
To calculate excel date quarter for a calendar year:-
To calculate the quarter number for a fiscal year ending in September:
This function is useful when you have to do certain analysis based on quarters and compare the data of one quarter with another.
Also, you can choose whether you need the quarter as per the financial year or as per the fiscal year and use the appropriate formula to give you the right quarter numbers for your data.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.