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