Fiscal year formula?

[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. D

 

[JE McGimpsey]

One way:

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

 

[StargateFanFromWork]

One way:

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

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!! D