ROUNDUP(5/3,0).
An easy formula that returns the quarter for a given date. There's no built-in function in Excel that can do this. 1. Enter the formula shown below. Explanation: ROUNDUP(x,0) always rounds x up to the nearest integer. The MONTH function returns the month number of a date. In this example, the formula reduces to =ROUNDUP(5/3,0), =ROUNDUP(1.666667,0), 2. May is in Quarter 2. Get quarter from date. If you want to calculate the quarter (i.e. 1,2,3,4) from a date, you can use the ROUNDUP function together with MONTH. For example, if you have the date January 9, 2016 in cell B4, this formula will return 1: 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. Finding Which Quarter a Date Is In. The formula for shifted quarters is similar, but shifts the month of the date by the number of months between January and the first quarter of the fiscal year. The example below illustrates how you can find a date’s quarter if Q1 starts in February instead of January. Calculating the quarter number corresponding with each of the dates listed in column A. Solution: To calculate the quarter number based on a calendar year, use the INT and MONTH functions in the following formula: =INT((MONTH(A2)-1)/3)+1. 1 Select the cell C5 and write the formula to calculate the quarter number. =” 2 Quarter”&MOD(CEILING(22+MONTH(A5)-9-1,3)/3,4)+1&” “&YEAR(A5) and press Enter on the keyboard. 3  This function will return the Quarter no. according to the fiscal calendar which is Quarter 1 2013.
http://www.excel-easy.com/examples/quarter.html https://exceljet.net/formula/get-quarter-from-date http://www.exceltip.com/excel-date-time-formulas/calculating-the-quarter-number.html https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm&language=en_US http://www.exceltip.com/excel-date-time-formulas/calculating-the-quarter-number-for-calendar-and-fiscal-year.html http://www.exceltip.com/excel-date-time-formulas/calculating-the-quarter-number.html
formula to find quarter from date