Excel Formulas to Get the Fiscal Quarter From the Given Date!!
Tags: excelformula, excelformulas
Published: 2021-05-17 10:20:01

---
title: Excel Formulas to Get the Fiscal Quarter From the Given Date!!
published: true
date: 2021-05-15 08:55:17 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-the-fiscal-quarter-from-the-given-date/
---

If you have a list of dates in a worksheet, and you want to quickly confirm the **fiscal quarter from the given date**. How could you deal with this task in Excel? You can read this tutorial, I think you may find the solution. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get fiscal quarter from date](https://geekexcel.com/wp-content/uploads/2021/05/Get-fiscal-quarter-from-date.png)](https://geekexcel.com/excel-formulas-to-get-the-fiscal-quarter-from-the-given-date/get-fiscal-quarter-from-date/#main)<figcaption id="caption-attachment-42345">Get fiscal quarter from date</figcaption>

## General Formula:

- Use the below formula to get the fiscal quarter from date in Excel.

**=[CHOOSE](https://geekexcel.com/how-to-use-choose-function-in-microsoft-excel-2013/)([MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(date),1,1,1,2,2,2,3,3,3,4,4,4)**

## Syntax Explanations:

- **CHOOSE** – In Excel, the [**CHOOSE function**](https://geekexcel.com/how-to-use-choose-function-in-microsoft-excel-2013/) returns a value from the list of value arguments using a given position or index.
- **MONTH** – This function helps to return the month of a date. Read more on the **[MONTH Function](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)**.
- **Date**  – It specifies the input values from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s consider the below example image.

- Here, we will enter the input values in  **Column B**.
- Now we are going to find the fiscal quarter from the given dates.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-16.png)<figcaption id="caption-attachment-42346">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-49.png)<figcaption id="caption-attachment-42348">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-46.png)<figcaption id="caption-attachment-42347">Result</figcaption>

## Verdict:

In this tutorial, we have discussed how to get the **fiscal quarter from the given date in Excel**. Hope you like it. Please write us below if something is **unclear** or if you need further assistance on this subject.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Find the Earliest & Latest Dates From the Given Range!!](https://geekexcel.com/excel-formulas-to-find-the-earliest-latest-dates-from-the-given-range/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Calculate Days, Hours & Minutes between Two Dates!!](https://geekexcel.com/excel-formulas-to-calculate-days-hours-minutes-between-two-dates/)**
- **[Excel Formulas to Display the Current Date and Time ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-display-the-current-date-and-time/)**