Showing Month Abbreviation With Using 2 Characters

[Rick Rothstein]

or
=TEXT(A1+180,"yyyy/") & MID("JAFEMRALMAJNJLAUSEOCNODE",2*MONTH(A1+180)-1,2) & "/" &TEXT(A1+180,"dd")

Yes, using MID that way is a good idea. You can save a coupe of characters (and a concatenation) by moving the last slash into the last TEXT function call like this...

=TEXT(A1+180,"yyyy/") & MID("JAFEMRALMAJNJLAUSEOCNODE",2*MONTH(A1+180)-1,2) & TEXT(A1+180,"\/dd")