Extract financial year in Excel

If your year-end date is 30 June or 31 Mar, you will probably want a column to categorise things by financial year/fiscal year/reporting year. It can later be used in filters, pivot tables, SUMIFS etc.