Financial year calculation

I am working with Financial year that starts 28/09/2015 and ends 25/09/2016 and so on.

Is there a way to get a formula which can return value "FY16" if between above dates and "FY17" if between 26/09/2016 and 25/09/2017

Thanks

Try this ...

="FY"&TEXT(A1+97,"YY")

Thanks for your replies.
Can it be made into a running formula. I mean just to drag it down based on the range set for the various financial years.

Please see attached excel file. Cells in column B should be the formula based on the date in column A.

Thanks again

Try this formula in post #3:

="FY"&TEXT(A2+97,"YY")

Or:

=LOOKUP(2,1/($F$2:$F$3<=A2)/($G$2:$G$3>=A2),$H$2:$H$3)

Thanks works well