Date Format

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

=UPPER(TEXT(J3,"dd mmm yyyy"))

But not sure how to put both together

Thanks in Advance

Formula:

=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)

In cell that you use this formula, use custom format like this

Formula:

dd mmm yyy

Ok. sorry didn't understoond. Try this

Formula:

=UPPER(TEXT(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),"dd mmm yyyy"))

You are welcome and thanks for the feedback & rep.