Financial Year Formula

// Financial Year Formula

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.