Converting a Date/Time to Month

[candybg]

I've got data exported from our system that shows this in the date column, cell C5:
01/01/2016 5:45:34 AM
I need another column (B5) to show either JAN or Jan 16 (caps irrelevant).
I tried LEFT(C5,10) but it returns 42370.2399 (and I understand why).
I tried DATE and DATEVALUE but obviously they don't work.

Is there a formula that can get me to JAN or JAN16?

Thanks!

[JieJenn]

=TEXT(C4, "mmm yy")

[candybg]

Worked perfectly - thanks so much!
Reputation * given

[MrShorty]

Exactly what do you need?

You can use =C5 in B5, then format as "mmm". Cell B5 will contain the exact same date/time serial number as C5, but will be formatted to only display the three letter month name.
You can use =INT(C5), then format as "mmm". Cell B5 will contain the "date" part of the date/time serial number, and can be formatted as above.
You can use MONTH(C5) to return the month number, then use a lookup value to get the desired "text string" to go with it. =INDEX({"Jan","Feb",...},MATCH(MONTH(C5),{1,2,3...},0)). Note that, in this variation, the result is not a date/time serial, but a text string.
I'm sure there are other approaches and variations.

[candybg]

Thanks so much for your input.