Oct 1 to Sep 30 date to fiscal year formula?

[leaning]

Hello!
What is the best method to find the last digit and last 2 digits of the fiscal year (Oct 1- Sep 30) corresponding to the date in A1?

1/1/2011 would be 1, etc.

??
Thanks for the help!
VR/Lost

[edvwvw]

Hi

Answered a slightly different question - please disregard

edvwvw

[leaning]

Hello!

This seems to work OK to determine the Oct 1 - Sep 30 FY from the date in A1. Then I can just use the RIGHT function to get the last 2 digits.

=IF(INT((MONTH(A1)+2)/3)=4,YEAR(A1)+1,YEAR(A1))

Anything shorter than this out there?

VR/Lost

[DonkeyOte]

Not entirely sure I follow but:

=RIGHT(YEAR(A1)+(MONTH(A1)>9),1)

modify 1 to 2 for 2 digits - note the above is returning said digits as a string rather than a number (use coercion or a MOD construct to return as number)

[daddylonglegs]

Anything shorter than this out there?

Try this formula to give the full year

=YEAR(A1+92)

if you want just the last 2 digits of the year

=TEXT(A1+92,"yy")