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. (Have since found out Matt learned the technique from David Marriott) You can add 184 to the date and then use the YEAR function. … Continue reading Easy Financial Year Formula