Format a Formula as a Date

[BrianExcel]

Right now I am using the simple formula =MONTH(A1) & "/" & (YEAR)(A1) to pull certain values out of an existing date.

What I need to do now is format that date to show mmm-yy (as in AUG-11).

I have tried using the custom box in cell format but it didn't work. I was hoping there was some way to specify formatting within the formula itself, like:

=MONTH(A1) & "/" & (YEAR)(A1), "mmm-yy"

Any thoughts? and thanks.

 

[SteveO59L]

Why not just format the cell as mmm-yy, and simply reference =a1

 

[SteveO59L]

But if you must do it that way, then

=TEXT(MONTH(A1)&"/"&YEAR(A1),"mmm-yy")

 

[BrianExcel]

Awesome. Thanks Steve.