Hi

I have a cell (B5) with the date 1/8/13 - (formatted as Aug 13 which changes each month.)

I would like to have a formula that uses this cell with other narrative

So I would like to get Aug 13 YTD as the result of the cancatination


I have
=B5 &" " & "YTD"
This returns 41487 YTD and not Aug 13 YTD

Tried a fair few formats etc, but no joy...

Any help greatly appreciated