Excel Formulas to Get Fiscal Year From the Date ~ Quick Tricks!!
Tags: excelformula, excelformulas
Published: 2021-05-17 10:20:24

---
title: Excel Formulas to Get Fiscal Year From the Date ~ Quick Tricks!!
published: true
date: 2021-05-15 10:41:10 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-fiscal-year-from-the-date-quick-tricks/
---

As we all known how to [**get the fiscal quarter from the date in Excel**](https://geekexcel.com/excel-formulas-to-get-the-fiscal-quarter-from-the-given-date/). Likewise, here we are going to learn the formula to **get the fiscal year from the date in Excel**. Let’s jump 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 year from a date](https://geekexcel.com/wp-content/uploads/2021/05/Get-fiscal-year-from-a-date.png)](https://geekexcel.com/excel-formulas-to-get-fiscal-year-from-the-date-quick-tricks/get-fiscal-year-from-a-date/#main)<figcaption id="caption-attachment-42397">Get fiscal year from a date</figcaption>

## Generic Formula:

- If you want to get a fiscal year from a date, you can use the below formula.

**=[YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(date)+([MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(date)>=startmonth)**

## Syntax Explanations:

- **YEAR** – In Excel, the **[YEAR Function](https://geekexcel.com/how-to-use-year-function-in-excel-365/)** helps to extract the year from the given date and returns the year as a 4-digit number.
- **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.
- **Plus operator (+)** – This symbol is used to add the values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.

## Example:

Let’s consider the below example image.

- First, we will enter the input dates in **Column B**.
- Here, we are going to find the fiscal year from the date.

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

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

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-50.png)<figcaption id="caption-attachment-42396">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-47.png)<figcaption id="caption-attachment-42395">Result</figcaption>

## Closure:

From this tutorial, you can get to know the easiest ways to **get the fiscal year from the date in Excel**. I hope that this article is helpful. If you have any other  **ideas**  or  **question** , do share with us here in the  **comments**  section below.

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 Also:

- **[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 Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Excel Formulas to Extract the Date from Date and Time ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-extract-the-date-from-date-and-time/)**
- **[Excel Formulas to Display the Current Date and Time ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-display-the-current-date-and-time/)**