Extracting last year and month

[howard]

1) I have date month and year in cell S5 on sheet1 as for eg 22/03/2013 (dd/mm/yyyy)
2) I have the month and year in S4 in sheet1 for eg Feb 2013

I have the following formula in C5 on sheet extact ="To "&MID(Sheet1!S5,9,2)&"/"&CHOOSE(MONTH(Sheet1!S4),1,2,3,4,5,6,7,8,9,10,11,12)

This returns To 13/2

If the month is less than 10, then I would like to add a zero after / for eg To 13/02 (for Feb 2013) , 13/03 (march 2013) etc

Your assistance in resolving this is most appreciated

 

[FormR]

Does this alternative do what you want?

="To " & TEXT(Sheet1!S5,"yy") & "/" & TEXT(Sheet1!S4,"mm")

 

[howard]

Thanks for the help, much appreciated