Showing Month Abbreviation With Using 2 Characters

**snb** · 11-25-2013, 03:15 PM

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

**Rick Rothstein** · 11-25-2013, 09:02 PM

Originally Posted by snb

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