How to Find a Quarter Corresponding to a Date in Excel

A quarter stands for a one fourth of a value. Because a calendar year consists of 12 months, a year quarter includes three months. Microsoft Excel is a popular spreadsheet program. This program allows you to set relationships between cells in the spreadsheet based on built-in formulas. Using this feature you instantly determine a quarter for any date entered into a spreadsheet cell.

Instructions

1. Open Microsoft Excel

2. Right-click on the cell "A1" in the Excel worksheet.

3. Choose the option "Format Cells" in the context menu, and then select the tab "Number."

4. Choose the category "Date" and select the desired date format, for example, "14-Mar-2001" in the field "Type." Then click "OK."

5. Enter the date in the cell "A1." For instance, enter "6/14/09" Note the date will be displayed accordingly the format chosen; in our example it will be "14-Jun-2009."

6. Click on any other cell (for instance, "C2") and type "=" on the keyboard.

7. Type "ROUNDUP(MONTH(A1)/3,0)" and press "Enter." The quarter corresponding to the date in the cell "A1" will display in the cell "C2." In our example, you will see "2" - the second quarter for the date 14-Jun-2009.

8. Type another date in the cell "A1." The quarter number will automatically update in the cell "C2."

References

• PCmag: Dates To Quarters In Excel
• Microsoft Office Online: ROUNDUP function