With your date in cell A1, try the following:

=IF(MONTH(A1)<7,RIGHT(YEAR(A1)-1,2)&"/"&RIGHT(YEAR(A1),2),RIGHT(YEAR(A1),2)&
"/"&RIGHT(YEAR(A1)+1,2))


Mangesh



"James B" <James wrote in message
...
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