Input Fiscal Year.

  • Thread starter Thread starter David Stricklen
  • Start date Start date
D

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
 
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)
 
Back
Top