The most common financial year formula for Google Sheets looks a little like this:
=IF(MONTH(A3) < 7, YEAR(A3) - 1, YEAR(A3))
Where:
=IF(MONTH(date) < financial_year_starting_month, YEAR(date) - 1, YEAR(date))
In Australia, our financial year starts on the 1 July. So that’s what I’ve used in the example.
Continue reading “A Better Financial Year Formula In Google Sheets”