I have a list of dates and would like to be able to tell which financial year
(1/07 €“ 30/6) each particular date fell into. I need something to
automatically work out the Fin Year column in the example below.

eg:
Date Fin Year
1/4/05 04/05
31/6/05 04/05
1/7/05 05/06

Thanks in advance