Financial Year formula

Is there an easy formula to determine the financial year from a date?

By Neale Blackwood

The following formula will calculate the financial year from a date in cell A1, assuming a July to June financial year that uses June year to refer to the financial year. For example, June 2005 is in the 2005 financial year.

=IF(MONTH(A1)<7,YEAR(A1),YEAR(A1)+1)