<div>
Assuming that you get 1 on Oct 1st then try<br />
<br />
=TODAY()-DATE(YEAR(TODAY()<wbr />+92)-1,10,<wbr />1)+1<br />
<br />
or put =TODAY() in A1 and use<br />
<br />
=A1-DATE(YEAR(A1+92)-1,10,<wbr />1)+1<br />
<br />
regards, barry
</div>


Assuming that you get 1 on Oct 1st then try

=TODAY()-DATE(YEAR(TODAY()+92)-1,10,1)+1

or put =TODAY() in A1 and use

=A1-DATE(YEAR(A1+92)-1,10,1)+1

regards, barry

26877262.xls

<div>
Wonderful! &nbsp;Thanks!!!! &nbsp; --Andres
</div>


<div>
<div class="content wysiwyg-content">
What Excel worksheet formula or VBA script will give the number of days since the start of the fiscal year.<br />
The start of the fiscal year will always be Oct 1st.<br />
The formula must work for the next 10 years (through 2020)<br />
<br />
Thanks, --Andres
</div>
</div>


What Excel worksheet formula or VBA script will give the number of days since the start of the fiscal year.
The start of the fiscal year will always be Oct 1st.
The formula must work for the next 10 years (through 2020)

Thanks, --Andres

Formula for number of days since start of fiscal year

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