How to Convert a Date into Fiscal Year

The fiscal year is commonly used in the government for accounting and budget purpose. The start date varies from countries, e.g., some countries start in April while some countries start in October.

Here is the fiscal year example list when the fiscal year starts in October.

1. Fiscal Year is the same as Calendar Year (e.g., 2018):

If the fiscal year starts January, the fiscal year is the same as the calendar year. Please use the Year Function:

=YEAR(A2)

2. Fiscal Year is the Calendar Year in which it Ends (e.g., 2018)

If the fiscal year starts a month from February to December, the identification of a fiscal year is the calendar year in which it ends. The fiscal year that begins on 1 October 2014 and ends on 30 September 2015 will be 2015 fiscal year. Please copy the formula below:

=IF(MONTH(A2)>=10, YEAR(A2)+1, YEAR(A2))

Where 10 is the fiscal year starting the month and can be changed to any month except January.

3. Fiscal Year using Two Years (e.g., 2015 - 2016)

In some countries, when the fiscal year crosses two years, people like to use the combination of the two years as the fiscal year, for example, the fiscal year 2015-2016 or 2015-16.

Please use the formula below if you want to want the "2015-2016" style.

=IF(MONTH(A2)>=10, TEXT(YEAR(A2) & " - " & (YEAR(A2)+1),"0"), TEXT((YEAR(A2)-1) & " - "&YEAR(A2),"0"))

Where 10 is the start month and you can change it to any month except January.

4. Fiscal Year using Two Years (e.g., 2015 - 16)

If you want to the results return "2015-16" style, please use the formula below:

=IF(MONTH(A2)>=10, TEXT(YEAR(A2)&" – " & (TEXT(A2,"YY")+1),"0"), TEXT((YEAR(A2)-1) & " – " & TEXT(A2,"YY"),"0"))

Where 10 is the start month and you can change it to any month except January.

Leave a Reply