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)