Hi,
I have a formula that outputs a date 9 months in advance i.e 15 Oct 2014, how do I format the date to output 15 OCT 2014?
=IF(DAY(DATE(YEAR($J$3),MONTH($J$3)+9,DAY(J3)))=DAY($J$3),DATE(YEAR($J$3),MONTH($J$3)+9,DAY($J$3)),DATE(YEAR($J$3),MONTH($J$3)+(9+1),1)-1)
I know I can format a cell using
But not sure how to put both together=UPPER(TEXT(J3,"dd mmm yyyy"))
Thanks in Advance
Bookmarks