Simple (I Think) Date Formula Needed

B

Big Rick

Hello All
In a cell, I have the start date of the current tax year(Apr 05)
In another cell (Say A2) I would to read "FOR THE TAX YEAR APR 05 to MAR 06"
Any help would be greatly appreciated.


Thanking you all in anticipation
 
B

Big Rick

Thanks, but this obviously changes each year, and would like that cell to be
totally automated. ie. if a1 was Apr 07, a2 would automatically read "For The
Year Apr 07 to Mar 08.

Hoping you can help me further
 
D

Dave Peterson

="FOR THE TAX YEAR " & UPPER(TEXT(A2, "mmm yy")) & " to MAR 06"

or maybe...

="FOR THE TAX YEAR " & UPPER(TEXT(A2, "mmm yy")) & " to "
&UPPER(TEXT(DATE(YEAR(A2),MONTH(A2)+11,1),"mmm yy"))

(all one cell)
 
B

Big Rick

You are a genius. Many Thanks
--
Big Rick


Dave Peterson said:
="FOR THE TAX YEAR " & UPPER(TEXT(A2, "mmm yy")) & " to MAR 06"

or maybe...

="FOR THE TAX YEAR " & UPPER(TEXT(A2, "mmm yy")) & " to "
&UPPER(TEXT(DATE(YEAR(A2),MONTH(A2)+11,1),"mmm yy"))

(all one cell)
Click to expand...
 
Top