Easy Financial Year Formula

To get the Australian financial year from a date you usually use an IF function based on the month number.

I recently learned a new hack from Matt Allington of Exceleratorbi.

You can add 184 to the date and then use the YEAR function. See table and formulas below.

The formula in cell B2 is

=YEAR(A2)

The formula in cell C2 is

=YEAR(A2+184)

Both formulas have been copied down.

A simple solution to a frustrating issue. Thanks Matt.

Please note: I reserve the right to delete comments that are offensive or off-topic.