Input Fiscal Year.

[David Stricklen]

I've been trying to create a formula that would convert a day into the current fiscal year, For instance, July 1st is the beginning of fiscal year 08, so if cell b3 reads 7/15/07, I would like cell a3 to read FY 08.

Thanks in advance,
David

 

[Ron Coderre]

Try this:
A3: ="FY "&RIGHT((YEAR(B3)-(MONTH(B3)<7)),2)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)