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.

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

2017-03-08T03:53:58+00:00 Functions|