Perfect! Thank you!

SJ
"T. Valko" wrote in message ...
Try one of these:

=TEXT(A1,"mmm")

That will return the short month name as a TEXT value = Jan

=TEXT(A1,"mmm-yy")

Will return the TEXT value Jan-08



--
Biff
Microsoft Excel MVP

--
Biff
Microsoft Excel MVP


"SSJ" wrote in message ...
Hello,

I am using the following formula to extract month from the date:

=month(a1)

The result is 1

What I wan to see is Jan instead of 1.

Also what do I need to do if I want the result as Jan-08

Thanks
SJ