Oct 1 to Sep 30 date to fiscal year formula?

**leaning** · 12-14-2010, 10:29 PM

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** · 12-15-2010, 04:26 AM

Hi

Answered a slightly different question - please disregard

edvwvw

**leaning** · 12-15-2010, 08:24 AM

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** · 12-15-2010, 08:52 AM

Not entirely sure I follow but:

Please Login or Register  to view this content.

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)