Fiscal year formula?

  • Thread starter Thread starter StargateFanFromWork
  • Start date Start date
S

StargateFanFromWork

If I input 2000-2001 in, say, cell A2, what could be put in B2 to return the
actual dates for the fiscal year, which in this example would be
Apr.01.2000-Mar.31.2001?

Thank you. :oD
 
One way:

=TEXT(DATE(LEFT(A2,4),4,1),"mmm.dd.yyyy\-") &
TEXT(DATE(LEFT(A2,4)+1,4,0),"mmm.dd.yyyy")
 
JE McGimpsey said:
One way:

=TEXT(DATE(LEFT(A2,4),4,1),"mmm.dd.yyyy\-") &
TEXT(DATE(LEFT(A2,4)+1,4,0),"mmm.dd.yyyy")
Click to expand...

Excellent, that seems to work perfectly! I ended up replicating column B in
the print area with this formula so that if the cell to the left in column A
is blank, that the one in column B would look blank, too, without an error
code showing up. The modification looks like this:

=IF(A2<>"",TEXT(DATE(LEFT(A2,4),4,1),"mmm.dd.yyyy\-") &
TEXT(DATE(LEFT(A2,4)+1,4,0),"mmm.dd.yyyy"),"")

Thank you!! :oD
 
Back
Top