<div>
<pre><code class="code-1 nolinks" id="code-20-43053567-1">=IF(MONTH(A2)&gt;6,YEAR(A2) &amp; "/" &amp; (YEAR(A2)+1),(YEAR(A2)-1) &amp; "/" &amp; YEAR(A2))</code></pre>The above formula assumes that cell A2 contains a date and not text that looks like a date. A real date will change appearance when you change the cell format. Text displayed as a date will not.<br><br>The formula will also work if the dates in question are text--provided that your computer is set up to use Day/Month/Year format for dates.
</div>


=IF(MONTH(A2)>6,YEAR(A2) & "/" & (YEAR(A2)+1),(YEAR(A2)-1) & "/" & YEAR(A2))

The above formula assumes that cell A2 contains a date and not text that looks like a date. A real date will change appearance when you change the cell format. Text displayed as a date will not.

The formula will also work if the dates in question are text--provided that your computer is set up to use Day/Month/Year format for dates.

kerikeri

<div>
Oh wow. &nbsp;I had spent a few hours trying to work out a solution. &nbsp;Actually I'm in New Zealand and we are all isolated in our homes so your response is most appreciated. &nbsp;When every thing gets back to 'normal' my boss will be impressed. &nbsp;Thank you so much.
</div>


Oh wow.  I had spent a few hours trying to work out a solution.  Actually I'm in New Zealand and we are all isolated in our homes so your response is most appreciated.  When every thing gets back to 'normal' my boss will be impressed.  Thank you so much.

<div>
An even shorter formula<br><br><pre><code class="code-1 nolinks" id="code-20-43053593-1">=YEAR(A2 + 184) - 1 &amp; "/" &amp; YEAR(A2 + 184)</code></pre>
</div>


An even shorter formula



=YEAR(A2 + 184) - 1 & "/" & YEAR(A2 + 184)

<div>
<div class="content wysiwyg-content">
Determine the financial year based on a date column<br />
<br />
Surface Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Financial Year<br />
30/06/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016/2017<br />
1/07/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2017/2018<br />
<br />
The financial year goes from July 1 to June 30.
</div>
</div>


Determine the financial year based on a date column

Surface Date	Financial Year
30/06/2017	2016/2017
1/07/2017	2017/2018

The financial year goes from July 1 to June 30.

Formula to determine Financial Year based on a date column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.