As we all known how to get the fiscal quarter from the date in Excel. 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
Generic Formula:
- If you want to get a fiscal year from a date, you can use the below formula.
=YEAR(date)+(MONTH(date)>=startmonth)
Syntax Explanations:
- YEAR – In Excel, the YEAR Function 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.
- 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.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)