Days in Financial Year
The DATE function
By Neale Blackwood
As a follow up to the tip on calculating the number of days into the calendar year, here is a formula to calculate the number of days into the 30 June financial year.
=IF(MONTH(A1)<7,A1-DATE(YEAR(A1)-1,6,30),A1-DATE(YEAR(A1),6,30))
First published: CPA AUSTRALIA Website 2009