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 haveThis returns 41487 YTD and not Aug 13 YTD![]()
=B5 &" " & "YTD"
Tried a fair few formats etc, but no joy...
Any help greatly appreciated
Bookmarks